HOUR 12. 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.
• Stored procedures process at the server (reduces required bandwidth).
• Stored procedures enable you to create reusable code.
• Stored procedures enable you to perform error-handling at the server.
• Stored procedures facilitate the security of data.
• Because stored procedures are pre-compiled, they execute ...
Get Sams Teach Yourself Microsoft SQL Server 2005 Express in 24 Hours now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
