Limit this search to....

Microsoft SQL Server 2005 Stored Procedure Programming in T-SQL & .Net
Contributor(s): Sunderic, Dejan (Author)
ISBN: 0072262281     ISBN-13: 9780072262285
Publisher: McGraw-Hill Companies
OUR PRICE:   $68.40  
Product Type: Paperback - Other Formats
Published: May 2006
Qty:
Annotation: 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 ProfessionalsGroup and execute T-SQL statements using batches, scripts, and transactionsCreate user-defined, system, extended, temporary, global temporary, and remote stored procedures Develop and manage stored procedures using C# and Visual Basic .NETImplement database access using ADO.NETCreate CLR user-defined functions and triggersImplement reliable debugging and error handling techniques and security measuresManage source code in a repository such as Visual SourceSafeCreate stored procedures for web search enginesUse system and extended stored procedures to interact with the SQL Server environment
Additional Information
BISAC Categories:
- Computers | Programming Languages - Sql
- Computers | Databases - General
- Computers | Certification Guides - General
Dewey: 004.36
LCCN: 2006281308
Physical Information: 1.52" H x 7.33" W x 9.14" (2.54 lbs) 664 pages
 
Descriptions, Reviews, Etc.
Publisher Description:
Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.


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 transactionsCreate user-defined, system, extended, temporary, global temporary, and remote stored procedures Develop and manage stored procedures using C# and Visual Basic .NETImplement database access using ADO.NETCreate CLR user-defined functions and triggersImplement reliable debugging and error handling techniques and security measuresManage source code in a repository such as Visual SourceSafeCreate stored procedures for web search enginesUse system and extended stored procedures to interact with the SQL Server environment

Contributor Bio(s): Sunderic, Dejan: -

Dejan Sunderic, 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.