Binding: Paperback Dewey Decimal Number: 005.2768 EAN: 9780072262285 ISBN: 0072262281 Label: McGraw-Hill Osborne Media Manufacturer: McGraw-Hill Osborne Media Number Of Items: 1 Number Of Pages: 664 Publication Date: May 18, 2006 Publisher: McGraw-Hill Osborne Media Sales Rank: 89178 Studio: McGraw-Hill Osborne Media
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
Customer Reviews
Average Rating:
Rating: - Easy to read explanations
I'm finding the book easy to read and understand. Some authors are hopeless, but this one is helpful
Rating: - Lacks Technical Editing
Like many IT and programming books, this one is no exception in that it seems to be riddled with small errors - things like showing a database schema and then referring to a table by an incorrect name. The most problematic issue with errors like this is that details really matter in these technical fields and it results in a "not ready for prime time" feel to the work. However, if the writer's teaching style appeals to your learning style, then go ahead, because at the end of the day that's what's ... Read More
Rating: - Stored Procedure Programming Inside Out
First off I know the author personally. In spite of that, the book definitely stands solidly on its own merits. This book is shock full of tips, tricks, angles and perspectives to maximize the use of stored procs in your SQL databases. Dejan really goes under the covers to the many aspects of SQL and the reader is the richer for it. This is a very important how to and reference for any serious SQL developer. You will go back to this book again and again. Highly recommended!
Rating: - Good reference on obscure parts of T-SQL
Dejan Sunderic, Microsoft SQL Server 2005 Stored Procedure Programming in T-SQL and .NET (McGraw-Hill, 2006)
Not a bad little book, this, though if you've had to dig into SQL2005 for work you're likely to have picked up on a good deal of this already. Still, Sunderic digs down into a number of places where most developers either don't normally have a reason to go or simply fear to tread. You're sure to find things in here you've overlooked (or never thought to look for) unless you're a guru, ... Read More
Rating: - Looking Pretty Good
I got this book for school, since it was required. Usually I'm skeptical about publishers other then O'reilly, WROX and Programmers for Programmers and maybe Friendsoft, since I think that quality of the book somehow depends on the publisher =), but this one is looking pretty good so far. I'm on the page 200 out of 650 and It's pretty clear, except for some minor points that I was able to search on the web for. I like it, it has some good examples and detailed enough explanation.
- Easy to read explanations
- Lacks Technical Editing
