"Writing Stored Procedures with Microsoft SQL Server"

eBook Name: Writing Stored Procedures with Microsoft SQL Server
eBook Type: SQL Server

SQL Server 2000, 2003, 2005

Writing Stored Procedures with Microsoft SQL Server: The Authoritative Solution

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, you're provided with guidance on making stored procedures that are portable across applications.