Essential for developers and database administrators who use SQL Server 2005 on a daily basis, this guide explains how to take full advantage of stored procedures: operations that are stored with the database server, allowing access to all clients. The book covers the design of stored procedures in both T-SQL and CLR languages such as Csharp and Visual Basic .NET and readers will learn to develop programmable database objects and scalable Web-based applications.
Essential for developers and database administrators who use SQL Server 2005 on a daily basis, this guide explains how to take full advantage of stored procedures: operations that are stored with the database server, allowing access to all clients. The book covers the design of stored procedures in both T-SQL and CLR languages such as Csharp and Visual Basic .NET and readers will learn to develop programmable database objects and scalable Web-based applications.
Dejan Sunderic (Toronto, Ontario) MCSD is the Principal Consultant at Sage Information Consultants, Inc., a consulting company based in Toronto specializing in development and infrastructure solutions.
Inhaltsangabe
From the 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
