Stored procedure in sql server

Stored procedure is very good example of sql scripting. Early in my career, i worked as a sql developer in that phase learnt a lot like how to write store procedures and triggers? How to implement business functionality using stored procedure without changing front-end code of the application? Writing scripts in sql server is less costly compare ...