Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 Other Topics
 Stored Procedure Tutorial

Author  Topic 

graz
Chief SQLTeam Crack Dealer

4149 Posts

Posted - 2000-08-13 : 00:00:00
Mike writes "Anybody know of a tutorial about the ins and outs of stored procedures? I am a bit of a newbie with SQL and am looking for info on how to create a stored procedure, syntax of them and how to call them from ASP & VB. . . . How much of a benefit would it be to use stored procedures over SQL statements?"

You can find a good intro to stored procedures here. Stored procedures almost always run faster than plain SQL. It also allows you to isolate your SQL code from your application.

   

- Advertisement -