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

by Dejan Sunderic (Author)
Key Phrases: set xact abort, expired lease schedule, deferred name resolution, Management Studio, Visual Studio, Visual Basic (more...)

Editorial Reviews

Product 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

From the Back Cover
 

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

 

See all Editorial Reviews

Product Details

• Paperback: 664 pages
• Publisher: McGraw-Hill Osborne Media; 3 edition (May 18, 2006)
• Language: English
• ISBN-10: 0072262281
• ISBN-13: 978-0072262285
• Product Dimensions: 8.9 x 7.2 x 1.5 inches
• Shipping Weight: 2.5 pounds (View shipping rates and policies)
• Average Customer Review: 4.0 out of 5 stars See all reviews (12 customer reviews)
• Amazon.com Sales Rank: #261,727 in Books (See Bestsellers in Books)

  Popular in these categories: (What's this?)

  #25 in	Books > Computers & Internet > Certification Central > MS SQL Server
  #80 in	Books > Computers & Internet > Microsoft > Development > .NET
  #81 in	Books > Computers & Internet > Certification Central > Publisher > Osborne-McGraw-Hill

Customer Reviews

Most Helpful Customer Reviews

7 of 7 people found the following review helpful:

4.0 out of 5 stars Helpful but needs improvement, April 12, 2007

By	Application Software Developer (Brookline, MA, USA) - See all my reviews

In SQL Server 2005 Stored Procedure Programming, Dejan Šunderic describes practical uses of T-SQL stored procedures well beyond the level of coverage reached by most other books dealing with SQL Server 2005, including the book on T_SQL programming by Itzik Ben-Gan, et al. Microsoft's documentation, while thorough, is useful mainly to provide reminders when one already knows the the structure.

Šunderic describes some of the interactions between SQL Server 2005 and Visual Studio languages, including of course the SQL Server 2005 techniques for using these languages to write stored procedures, but also showing how to use Visual Studio 2005 as a debugger for stored procedures written in T-SQL.

It would probably have been helpful for many readers had Šunderic described the main access classes that the Visual Studio languages provide to reach SQL Server, that is, the SqlConnection, SqlCommand, SqlParameter and SqlDataReader classes. This topic is missing or barely mentioned in every current book on SQL Server and the .NET and Visual Studio technologies.

It would also been of use to many readers had Šunderic shown examples utilizing some of the key improvements in SQL Server 2005, for example generating lightweight cursors on table variables and implementing messaging. Both are likely to involve stored procedures. A messaging discussion almost starts in the final chapter, where Šunderic seems to be running out of steam.

Overall, Šunderic has written an informative and helpful book that substantially augments information available from other books and from Microsoft documentation.

9 of 10 people found the following review helpful:

3.0 out of 5 stars Useful Information - Conceptual Organization Lacking, June 13, 2006

By	John M. Cunha "ThotWorks" (Windham, NH USA) - See all my reviews (REAL NAME)

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.

1 of 1 people found the following review helpful:

2.0 out of 5 stars Interesting - But not as Practical as I need.. ., January 22, 2009

By	S. Smith "iridium_hack" (VA USA) - See all my reviews (REAL NAME)

Be advised that in this book, the author is in a hurry to get to advanced concepts. Only the first three chapters could be called basic. After that, it quickly climbs to advanced material before (in my opinion) sufficiently covering basic and intermediate material. By Chapter 14, the subject is, "Advanced Stored Procedure Programming". But I still can't find what I need in 1-3. Then, as if it is even more advanced, the next subject (Chap 15) is "Debugging". Please, when will we have an author who sees that debugging is a progressively learned process? Perhaps there should be a section in a chapter early on covering debugging of basic stuff.

My background as a programmer of relational databases and writing SQL statements goes back over fifteen years. As my reports and SQL statements have gotten more complex to please the customer, I have had to move into writing stored stored procedures to meet the need for speed. My intent was to get a book that would help me get my SQL statements to work as Stored Procedures. This book appeared to match my customer's software make-up (MS SQL Server, Stored Procedures, .Net, T-SQL, etc) as well as being written in a fairly straightforward and easy to understand manner (it does get a big plus on that!). But if you haven't been writing stored procedures for a year or more, and you have little staff assistance where you are, I would not recommend this book. If on the other hand, you have been doing SP's for a few years or have lots of staff help and want to go the next step, this book may be for you. I'm going to get another one that will help get the basics to work.