book on stored procedures for SQL Server 2000

[rdshultz]

Would like to know if there is a book out there on stored procedures
that takes you step by step on how to create them. Have a book now
that shows examples of stored procedures but doesn't explain the code
very well and doesn't explain why you use certain code or exactly what
the code is doing. Any help is appreicated.

[Dimitri Furman]

On Jun 07 2004, 04:17 pm, rd******@nooter.com (rdshultz) wrote in
news:87**************************@posting.google.c om:

Would like to know if there is a book out there on stored procedures
that takes you step by step on how to create them. Have a book now
that shows examples of stored procedures but doesn't explain the code
very well and doesn't explain why you use certain code or exactly what
the code is doing. Any help is appreicated.

MS Access Developer's Guide to SQL Server, by Mary Chipman and Andy Baron.
An excellent book, especially if you already have some Access background.

--
remove a 9 to reply by email

[Larry Linson]

I believe Rebecca Riordan has a book on SQL Server 2000, as well. I don't
know who published it (she's worked with several different publishers) nor
how deeply it goes into Stored Procedures, but I do know she writes very
well, and explains very clearly. IMNSHO, it'd be worth a little searching at
the bookstore and auction sites to find it.

Larry Linson
Microsoft Access MVP

"Dimitri Furman" <df*****@cloud99.net> wrote in message
news:Xn****************************@127.0.0.1...

On Jun 07 2004, 04:17 pm, rd******@nooter.com (rdshultz) wrote in
news:87**************************@posting.google.c om:

Would like to know if there is a book out there on stored procedures
that takes you step by step on how to create them. Have a book now
that shows examples of stored procedures but doesn't explain the code
very well and doesn't explain why you use certain code or exactly what
the code is doing. Any help is appreicated.

MS Access Developer's Guide to SQL Server, by Mary Chipman and Andy Baron.
An excellent book, especially if you already have some Access background.

--
remove a 9 to reply by email

[John Winterbottom]

"rdshultz" <rd******@nooter.com> wrote in message
news:87**************************@posting.google.c om...

Would like to know if there is a book out there on stored procedures
that takes you step by step on how to create them. Have a book now
that shows examples of stored procedures but doesn't explain the code
very well and doesn't explain why you use certain code or exactly what
the code is doing. Any help is appreicated.

"Guru's Guide to Transact-SQL" and "The Guru's Guide to SQL Server Stored
Procedures, XML, and HTML" both by Ken Henderson, (the first is better for
learning straight T-SQL, but they're both excellent books.)

"SQL Server 2000 Stored Procedure Programming" by Dejan Sunderic.

Go to amazon.com and look through the reviews for these and other books on
the subject.

[rkc]

"Larry Linson" <bo*****@localhost.not> wrote in message
news:ay*************@nwrddc03.gnilink.net...

I believe Rebecca Riordan has a book on SQL Server 2000, as well. I don't
know who published it (she's worked with several different publishers) nor
how deeply it goes into Stored Procedures, but I do know she writes very
well, and explains very clearly. IMNSHO, it'd be worth a little searching at the bookstore and auction sites to find it.

2nd opinion: Not worth considering.