Q

Stored procedures in Crystal Reports

Development expert Andrew Novick gives you the resources to improve your stored procedure writing skills.

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.
This was first published in September 2005

Dig deeper on Microsoft SQL Server Installation

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close