<b>教您若何利用sql语句删除全部存储历程</b>[MSSQL防范]

假如存储历程不需求了,该若何删除呢?下面将教您若何利用sql语句删除全部存储历程,供您参考,假如您不知道若何写这样的SQL语句,无妨一看,相信对您会有所帮忙.

declare @procName varchar(500)

declare cur cursor

for select [name] from sys.objects where type = 'p'

open cur

fetch next from cur into @procName

while @@fetch_status = 0

begin

if @procName <> 'DeleteAllProcedures'

exec('drop procedure ' + @procName)

fetch next from cur into @procName

end

close cur

deallocate cur