- STAFF PICKS
- GIFTS + GIFT CARDS
- SELL BOOKS
- FIND A STORE
Used Trade Paper
Ships in 1 to 3 days
available for shipping or prepaid pickup only
Available for In-store Pickup
in 7 to 12 days
More copies of this ISBN
Sql Server 2000 Stored Procedure Prog. (3RD 06 Edition)by Sunderic
Synopses & ReviewsPlease note that used books may not include additional media (study guides, CDs, DVDs, solutions manuals, etc.) as described in the publisher comments.
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-SQLand.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
Essential for developers and database administrators who use SQL Server 2005 on a daily basis, this volume explains how to take full advantage of stored procedures. Covering the design of stored procedures in both T-SQL and CLR languages such as C# and Visual Basic .NET, this title shows how to develop programmable database objects and scalable Web-based applications.
About the Author
Dejan andScaron;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.
Table of Contents
Chapter 1: The SQL Server 2005 Environment and Tools
Chapter 3: Basic Transact-SQL Programming Constructs
Chapter 5: Composite Transact-SQL Constructs: Batches, Scripts, and Transactions
Chapter 7: Special Types of Stored Procedures
Chapter 9: Triggers
Chapter 11: Fundamentals of .NET Programming in SQL Server 2005
Chapter 13: CLR Functions and Triggers
Chapter 15: Advanced Stored Procedure Programming
Chapter 17: Source Code Management
Chapter 19: Security
Chapter 21: Interaction with the SQL Server Environment
APPENDIX B: STORED PROCEDURE COMPILATION, STORAGE, AND REUSE