Stored Procedures 1

[webmigit]

I've read that stored procedures run faster than direct queries which makes enough sense I guess..

Where can I find a tutorial on stored procedures? And what's the learning curve like on this? This is something I'll be researching mostly at work so is it really worthwhile to learn or are queries alright?

ALFII.com

http://www.alfii.com

---------------------
If this post answered or helped to answer your question, please reply with such so that forum members with a similar question will know to use this advice.

 

[SQLBill]

Stored procedures are very easy to create and use.

Refer to the BOL for more information. Use the Index tab, enter Stored Procedure and chose the option with Location of Transact-SQL.

-SQLBill

BOL = Books OnLine = MS SQL Server's HELP
Installed as part of the Client Tools
Found at Start>Programs>Microsoft SQL Server>Books OnLine
Can also be downloaded from Microsoft's web site. Search for Books OnLine and SQL Server

 

[webmigit]

Thanks much for the typically fast response one gets from Tek Tips.. And for being straight to the point but informative.

ALFII.com

http://www.alfii.com

---------------------
If this post answered or helped to answer your question, please reply with such so that forum members with a similar question will know to use this advice.

 

[SQLBill]

You are welcome and thanks for the star.

-SQLBill