A Good Stored Proc Template - What Are Your Views?

Hi,

I'm curious to know what templates/standards you guys use for T-SQL stored procs. I've been using the following standard:




Code Snippet
IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = '<proc name>')
BEGIN
DROP Procedure <proc name>
END
GO

CREATE PROCEDURE <proc name>
@parm1,
@parm2
AS
BEGIN TRANSACTION <transactionName>;
BEGIN TRY
--DO WORK HERE
END TRY
BEGIN CATCH
SELECT
ERROR_NUMBER() AS ErrorNumber,
ERROR_SEVERITY() AS ErrorSeverity,
ERROR_STATE() as ErrorState,
ERROR_PROCEDURE() as ErrorProcedure,
ERROR_LINE() as ErrorLine,
ERROR_MESSAGE() as ErrorMessage;
IF @@TRANCOUNT > 0
ROLLBACK TRANSACTION <transactionName>;
END CATCH;
IF @@TRANCOUNT > 0
COMMIT TRANSACTION <transactionName>;
ELSE

ROLLBACK TRANSACTION <transactionName>;
GO




If you guys have any advice/critisizm, please post it as I'm constantly looking into bettering this as much as possible.

Regards
Michael