电子书免费下载 Microsoft SQL Server 2005 Stored Procedure Programming in T-SQL and .NET, Third Editi

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 & execute T-SQL statements using batches, scripts, & transactions;

- Create user-defined, system, extended, temporary, global temporary, & remote stored procedures;

- Develop & manage stored procedures using C# & Visual Basic .NET;

- Implement database access using ADO.NET;

- Create CLR user-defined functions & triggers;

- Implement reliable debugging & error handling techniques & security measures;- Manage source code in a repository such as Visual SourceSafe;

- Create stored procedures for web search engines;

- Use system & extended stored procedures to interact with the SQL Server environment.