IF EXISTS (SELECT * FROM sysobjects WHERE TYPE='P' AND name='SP_NAME')DROP PROCEDURE SP_NAMEGO--该片段来自于http://www.codesnippet.cn/detail/090420132758.html
来源: http://www.codesnippet.cn/detail/090420132758.html