Writing Stored Procedures for Microsoft SQL Server

About this book

Writing Stored Procedures for Microsoft SQL Server focuses on teaching you not only how to build effective stored procedures but also how to optimize and streamline them for long term use. Get an understanding of how SQL Server interprets stored procedures verses direct access via SQL queries. This is followed by detailed instructions on creating and maintaining a repository of stored procedures. Once you know how stored procedures are created and built you are taught how to determine which logic within an application makes sense to be put into this scheme. Additionally youre provided with guidance on making stored procedures that are portable across applications.