->在name对应的值,输入存储过程名称选择存储过程,
右键->编写存储过程脚本为->DROP到,把那段脚本去掉use那一行,
复制到存储过程的前面就OK了。
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'Proc_InsertDownloadJobLog') AND type in (N'P', N'PC'))
DROP PROCEDURE Proc_InsertDownloadJobLog
go
复制到存储过程的前面就OK了。
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'Proc_InsertDownloadJobLog') AND type in (N'P', N'PC'))
DROP PROCEDURE Proc_InsertDownloadJobLog
go