Stored procedures

[Adrian]

I am looking for a good tutorial
on stored procedures on the Web.
Any suggestions where to look?

Thanks.
Adrian.

 

[Cor Ligthert [MVP]]

Adrian,

A stored procedure is nothing more than a piece of SQL transaction code
saved in the database.

Therefore just have a look at that.

http://www.vb-tips.com/dbpages.aspx?ID=1b31f4f7-0596-4b8e-aaf5-e16db864a414

See the last line in this.

I hope this helps,

Cor

 

[Adrian]

The page cannot be displayed
Adrian

Adrian,

A stored procedure is nothing more than a piece of SQL transaction code
saved in the database.

Therefore just have a look at that.

http://www.vb-tips.com/dbpages.aspx?ID=1b31f4f7-0596-4b8e-aaf5-e16db864a414

See the last line in this.

I hope this helps,

Cor

 

[Adrian]

At first the reference produced errors (not available).
Later on I got through alright.
I see there is a wealth of information available there.
After my post I found this reference myself.
http://www.sql-server-performance.com/tn_stored_procedures.asp

Thank you for your response.
Much appreciated.

Adrian.

 

[clintonG]

Read and study the stored procedures that your databases already use. This
is especially useful if your using ASP.NET 2.0 Membership. Microsoft names
their stored procedures using the sp_ prefixed notation noting your notation
should be named differently. Learning why can also be found searching the
web.

 

[Earl]

Nothing like a good book or two just on SQL. It's a language all unto
itself, one which you will need to know in order to write good stored
procedures.