what are store procedure and how to add store procedure in the crystal 1

[abhishekpant]

i have just started working with crstal report and i have been struggling with sql querries and store procedures. Are store procedure are sql queries?

 

[fredp1]

If you have just started working with Crystal, then I would suggest to start with queries.

A stored Procedure (sp for short), is a bunch of code that lives and runs on the db server. Becasue it lives on the server it normally runs a bit faster. It may contain one or more sql queries and additional code. You may create temp tables, new tables, run os commands etc.
Sometimes when you have a really complex problem to solve or when performance is important, you may need a sp.
Personnaly I've only had to use a sp in a report 2 times in 200 reports. If I was using v9 and up, I wouldn't use a sp. (i'm using 8.5)
A query is created by the client(crystal) sent to the server, then the server optimises the way data will be pulled from the server, then the results are returned to the client.
Bottom line... stick to queries.
Have a look at the FAQ for any books on this formum an on the SQL server programming forum.


Cheers
Fred

 

[abhishekpant]

so you means that knowledge of sql query is more important than store procedure. I am comfortable with sql query but i have never done store procedure and I have some interview lined up for next week.
Any suggestion?

 

[fredp1]

You'll need SQL(queries) BEFORE you get near sp's.
In SQL Server there is BOOKS ONLINE (BOL) which covers everything for SQL Server.


Good luck with the interview!


Cheers
Fred