Microsoft SQL Server 2005 Stored Procedure Programming in T-SQL & .NET, 3/e (Paperback)

Create and Use Stored Procedures for Optimal Database Performance

Develop complex stored procedures to retrieve, manipulate, update, and delete data. Microsoft SQL Server 2005 Stored Procedure Programming in T-SQL & .NET identifies and describes the key concepts, techniques, and best practices you need to master in order to take full advantage of stored procedures using SQL Server's native Transact-SQL and .NET CLR languages. You'll learn to incorporate effective Transact-SQL stored procedures into client or middleware code, and produce CLR methods that will be compiled into CLR stored procedures. This is a must-have resource for all SQL Server 2005 developers.

Essential Skills for Database Professionals

• Group and execute T-SQL statements using batches, scripts, and transactions
• Create user-defined, system, extended, temporary, global temporary, and remote stored procedures
• Develop and manage stored procedures using C# and Visual Basic .NET
• Implement database access using ADO.NET
• Create CLR user-defined functions and triggers
• Implement reliable debugging and error handling techniques and security measures
• Manage source code in a repository such as Visual SourceSafe
• Create stored procedures for web search engines
• Use system and extended stored procedures to interact with the SQL Server environment

 

 

Table of Contents

Chapter 1: The SQL Server 2005 Environment and Tools
Chapter 2: Stored Procedure Design Concepts
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