ISBN:0072262281Book Description
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
Reviews From AMAZON.COM
Excellent book for SQL developers!
The best SQL 2005 book for developers that I've seen so far!
Very clear content and easy to upgrade your knowledge from SQL 2000. While the book is focused on the new Features of SQL Server 2005 it addresses also non-new features.
I especially like the tips and samples which are tailored for "real life"
The .Net samples are part in C# and part in VB. I wish they were all in C#.
Highly recommended for any SQL 2005 developer!
Useful Information - Conceptual Organization Lacking
This book contains much useful information on SQL Server 2005 T-SQL enhancements, but it regularly employs functions and constructs in its examples that are only explained in later passages. Specifically, when attempting to absorb a new concept by examining a code example, you must also contend with looking up items which have not yet been covered. This is a mild stumbling block but it hurts the flow of the book.
Also, the practice database (Asset5) did not attach properly (on my SQL Server 2005 STD edition install regarding appropriate permissions to modify objects) and the most direct workaround was: (1) To use the included, but unreferenced script to initialize the database and all its objects using a "new name" for the database (2) Attach the original database - Asset5 (3) Use the data import feature to populate the "new name" database tables (4) Drop the attached database Asset5 (5) Rename the "new name" database to Asset5. I did first attempt to modify the permissions associated with the login I was using - unsuccessfully...
By way of comparison I am using Oracle Press' "Oracle 9i The Complete Reference" by Koch and Loney as a standard of clarity and conceptual organization for PL-SQL. It is on this basis that I assign this book 3 stars, but admit that I have yet to discover a better book for advanced T-SQL topics. Please feel free to forward me better titles.
As an aside, Murach's SQL for SQL Server is the best introductory text I have found for T-SQL.