Creating Stored Procuders

Hello All,
I am looking for standards for creating stored procedures. I am trying to
come up with a templete that we could use for consistancy. If anyone has any
Ideas I would appreciate it.
Thanks
Anthony Dawson MCSE *3, MCDBA
Hi
Query Analyser has some simple templates for creating a procedure look at
the File/New options. You may want to add a mandatory SET NOCOUNT ON, for an
insert/update procedure you may want to add a standard BEGIN TRANSACTION
block that checks for existing transactions and similary a COMMIT/ROLLBACK
section. You may want to look at
http://www.sommarskog.se/error-handling-II.html
John
"Anthony Dawson" <Anthony Dawson@.discussions.microsoft.com> wrote in message
news:829FDD04-9905-4CCA-8788-58336C5B3207@.microsoft.com...
> Hello All,
> I am looking for standards for creating stored procedures. I am trying to
> come up with a templete that we could use for consistancy. If anyone has
any
> Ideas I would appreciate it.
> Thanks
> Anthony Dawson MCSE *3, MCDBA
|||Thanks I will check those templates out.
"John Bell" wrote:

> Hi
> Query Analyser has some simple templates for creating a procedure look at
> the File/New options. You may want to add a mandatory SET NOCOUNT ON, for an
> insert/update procedure you may want to add a standard BEGIN TRANSACTION
> block that checks for existing transactions and similary a COMMIT/ROLLBACK
> section. You may want to look at
> http://www.sommarskog.se/error-handling-II.html
> John
> "Anthony Dawson" <Anthony Dawson@.discussions.microsoft.com> wrote in message
> news:829FDD04-9905-4CCA-8788-58336C5B3207@.microsoft.com...
> any
>
>