Microsoft SQL Server 2005 Stored Procedure Programming in T-SQL & .NET

Microsoft SQL Server 2005 Stored Procedure Programming in T-SQL & .NET

by Dejan Sunderic
     
 

View All Available Formats & Editions

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

…  See more details below

Overview

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

Read More

Product Details

ISBN-13:
9780072262285
Publisher:
McGraw-Hill Professional Publishing
Publication date:
05/18/2006
Edition description:
REV
Pages:
664
Product dimensions:
7.30(w) x 9.10(h) x 1.35(d)

Meet the Author

Dejan Šunderić, MCDBA, is the principal consultant at Trigon Blue, Inc., and the president of the Toronto SQL Server User Group. He specializes in database and application development on the SQL Server platform.

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >