Rating: 
Summary: excellent book
Review: As a Visual Basic developer, I have been faced several times with the requirement to write database access components using only stored procedures. All the books on VB and SQL Server that I looked at seemed to focus on how to connect to SQL Server using ADO, RDO or ODBC, but I could never find a really comprehensive guide to using stored procedures. This is the first book I've seen that is dedicated to programming with stored procedures. Now I'm starting to understand what my DBA was talking about.
Rating:
Summary: Hello World!
Review: What I like most about this book is that the authors don't waste time (mine and theirs) with the trivial elements of TSQL such as select, insert, update and delete statements. Instead we get waluable information about how to use complex elements such as IF, WHILE, CURSOR, FUNCTION, new triggers, new data types and XML. But best of all, they showed me how to bring all of these elements together in stored procedures. I'd call this one a must have for SQL Server developers.
Rating:
Summary: Finally
Review: I have been looking for a book like this for two years. This is the first book I've found that goes beyond the usual trivial stored procedure examples with one or two select and/or insert statements. It has everything I need - loops, conditional execution, error handling, debugging, dynamic queries. And the sample database has some great, real-world examples of very complex stored procedures.
Rating:
Summary: SQL Server 2000 Stored Procedure Programming by Dejan Sunder
Review: I used to work a lot in Microsoft Access, but since Microsoft released MSDE as part of Access 2000, I am doing a lot more SQL Server projects. I recommend this book to you if you need to learn about TSQL and stored procedure development. However, this book is probably not the best place to start if you need to learn about basic database concepts like tables, indexes and select, update and insert statements. It's definitely for the intermediate to senior database developer. You should definitely get this book if you want to improve your ability to build complex stored procedures systematically.
Rating:
Summary: Great book
Review: Everybody's talking about XML these days and now even SQL Server supports it. This book has a great introduction to XML for DBAs-everything you ever wanted to know about tags, elements, attributes, DTDs, schemas and XPath, but were afraid to ask. After introducing XML, the authors go on to describe how Microsoft has implemented it in SQL Server, and how you can use it to build simple Web applications for querying databases and returning recordsets as XML or processing/parsing information received as an XML string. The authors also promise to cover updategrams and SOAP on their Web site (trigonblue.com) as soon as information becomes available.
Rating:
Summary: Finally good book
Review: Finally good book on the market for stored procedures. This book "shoots" directly at the hart of problem. Developers need tips and advanced technics, and you have it here. I recommend this book for every professional who want to be the best in DB programming. Try it, you'll find for long time searched solutions, I suppose.Regards Nikola
Rating: 
Summary: well written
Review: This is one of the clearest, most useful programming books I have ever run across in 18 years of programming! If you are doing anything more than writing simple queries, get this book. Highly useful for those developing ADO.NET SQL Server applications, because it covers all the nuances of SQL stored procedures and triggers that you'll want behind your ADO.NET apps. Also covers the differences between SQL 7 and 2000 clearly, and goes into automating administrative tasks via T-SQL, including the Windows registry. Has a good introduction to SQL XML.
Rating:
Summary: Great Book!!!!!
Review: The best thing about this book is that the author explains why you should do certain things. It explains how SQL Server works to process your request. This is the best SQL book I have read.
|
