Annotations for "CREATE PROCEDURE (Transact-SQL)" topic.Tue, 31 Mar 2015 18:28:42 Zhttp://technet.microsoft.com/en-US/library/ms187926(v=sql.90).aspx#CommunityContent
Gail EricksonWhy do a drop procedure before createWhy would you do a drop procedure before doing a create. The reference for Alter Procedure says "ALTER PROCEDURE does not change permissions and does not affect any dependent stored procedures or triggers. " So if you do a drop you would lose all of that. Seems to me if the procedure exists then there is a reason it exists and you would want to do a Alter Procedure rather than drop and recreate thereby losing all of your execute permissions. If it doesn't exist then why do a drop?[Gail ErickThu, 01 Mar 2012 01:41:38 -0800http://technet.microsoft.com/en-US/library/ms187926(v=sql.90).aspx#CommunityContent
Manoj Pandey (manub22)Best practices while creating Stored Procedures (SPs)Check this blog link to follow best practices while creating SPs: http://sqlwithmanoj.wordpress.com/2012/02/26/best-practices-while-creating-stored-procedures/Wed, 29 Feb 2012 05:16:53 -0800