best practices for writing SQL server stored procedures

Dear All,

Please suggest some of the best practices for writing SQL server
stored procedures?
I'm writing a business function (stored procedure), which calls
many-stored procedure one after another.
I want this to be best optimized, so that speed can be very good.

Suggestion in this regard will be appreciated.

Thanks in advance,
T.S.NegiHere are some of the best practices that I use:
http://www.extremeexperts.com/SQL/A...tPractices.aspx

--
HTH,
Vinod Kumar
MCSE, DBA, MCAD, MCSD
http://www.extremeexperts.com

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp

"T.S.Negi" <tilak.negi@.mind-infotech.com> wrote in message
news:a1930058.0502132116.761a1b9a@.posting.google.c om...
> Dear All,
> Please suggest some of the best practices for writing SQL server
> stored procedures?
> I'm writing a business function (stored procedure), which calls
> many-stored procedure one after another.
> I want this to be best optimized, so that speed can be very good.
> Suggestion in this regard will be appreciated.
> Thanks in advance,
> T.S.Negi