I am fairly new to SQL server and I need to create many (probably 50+) stored procedures. These stored procedures will be used by Crystal reports within an application. An application consultant explained a little about stored procedures to me, but I need to improve my skills before I will be able to perform this task. I have a fair amount of experience query writing with Access and VBA, and understand relational databases. Any suggestions on a few good books about stored procedures and possibly courses (in the Toronto, Canada) would be appreciated.
The book on stored procedures that I like the most is
Advanced T-SQL for SQL Server 2000
by Itzak Ben-Gan and Tom Moreau. It has everything you're going to need to write reporting stored procedures. Another great book on advanced SQL topics, not specific to SQL Server is Joe Cleko's
SQL for Smarties
Do you have comments on this Ask the Expert Q&A? Let us know.
Dig Deeper on Microsoft SQL Server Installation
Can't decide whether to use nullable fields in a table. Development expert Andrew Novick discusses what to do.
If you've had trouble connecting Visual Basic to SQL Server, let expert Andrew Novick offer some basic advice to get you started.
Development expert explains the simplest way to store an image in SQL Server.
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.