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 EXEC('drop procedure ' + @procName) FETCH next FROM cur INTO @procName END CLOSE cur DEALLOCATE cur
用户登录
还没有账号?立即注册
用户注册
投稿取消
文章分类: |
|
还能输入300字
上传中....