文档介绍：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 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 Topic
s
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 pilation,
Storage, and Reuse
Appendix C - Data Types in SQL Server 2005
Index
List of Figures
List of Tables
List of Sidebars
Back Cover
plex 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-SQ