Table of Contents

		Microsoft SQL Server 2005 Stored Procedure Programming in T-SQL & .NET, Third Edition byDejan Šunderi McGraw-Hill/Osborne 2006 (704 pages) ISBN:0072262281 Use this definitive resource to get key concepts, techniques, and best practices to help you take full advantage of stored procedures using SQL Server's native Transact-SQL and .NET CLR languages.

Table of Contents
	Microsoft SQL Server 2005 Stored Procedure Programming in T-SQL & .NET, Third Edition
	Introduction
	Chapter 1	-	The SQL Server 2005 Environment and Tools
	Chapter 2	-	Stored Procedure Design Concept
	Chapter 3	-	Basic Transact-SQL Programming Constructs
	Chapter 4	-	Functions
	Chapter 5	-	Composite Transact-SQL Constructs—Batches, Scripts, and Transactions
	Chapter 6	-	Error Handling
	Chapter 7	-	Special Types of Stored Procedures
	Chapter 8	-	Views
	Chapter 9	-	Triggers
	Chapter 10	-	User-defined Functions
	Chapter 11	-	Fundamentals of.NET Programming in SQL Server 2005
	Chapter 12	-	Fundamentals of CLR Stored Procedure Development
	Chapter 13	-	CLR Functions and Triggers
	Chapter 14	-	CLR Database Objects Advanced Topics
	Chapter 15	-	Advanced Stored Procedure Programming
	Chapter 16	-	Debugging
	Chapter 17	-	Source Code Management
	Chapter 18	-	Database Deployment
	Chapter 19	-	Security
	Chapter 20	-	Stored Procedures for Web Search Engines
	Chapter 21	-	Interaction with the SQL Server Environment
	Appendix A	-	Naming Conventions
	Appendix B	-	Stored Procedure Compilation, Storage, and Reuse
	Appendix C	-	Data Types in SQL Server 2005
	Index
	List of Figures
	List of Tables
	List of Sidebars