Lesson 13. Using T-SQL to Design SQL Server Stored Procedures
Stored procedures are at the heart of any client/server application. Using stored procedures, you can guarantee that processing is completed on the server. Stored procedures have many other benefits as well, including the following:
Stored procedures help you to separate the client application from the database’s structure.
Stored procedures help you to simplify client coding.