 See larger picture | Microsoft SQL Server 2005 Stored Procedure Programming in T-SQL & .NET
by
Dejan Sunderic
- McGraw-Hill Osborne MediaList Price: $59.99
Price at Amazon.com: $35.99
(Save
40%)
 Availability: Usually ships in 24 hours
Shipping rates and policies |
- Average Customer Review:
Based on
9
reviews.
- Amazon.com Sales Rank: 31737
|
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
Featured Customer Reviews  Stored Procedure Programming Inside Out,
January 30, 2008 Good reference on obscure parts of T-SQL,
January 03, 2008
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, and even then there might be a [...]bit or two. For someone who just got thrust into "we're upgrading!", it's been great. *** ½Looking Pretty Good,
October 21, 2007 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.
I give it 4 mainly cause nothing is perfect =)
Thanks,
AlexanderGreat learning and reference material,
May 25, 2007 I got this book as a present and started reading it immediately upon receiving it. I read it from cover to cover in about 2 nights. It lays next to my computer at work for constant reference. [...]
It is very informative and very well laid-out. I never once was lost and wondered what the author was talking about. It's vocabulary and grammer are just right for the advanced programmer to the programming newb.
I was able to excel my sql server skills very quickly with the help of this book. I suggest buying this book to all sql programmers new and old.Book Reviewer for .Net Developers Journal,
May 03, 2007 If you are looking for a good review of exisiting as well as new features available for T-sql and stored procedures in SQL Server 2005 , then this book will start you in the right direction. The author has many examples and useful insights peppered throughout the book. I do wish though that he used the AdventureWorks database instead of his own since Adventureworks is the new demo database provided by Microsoft.
You might also be interested in these items...
|
|