删除所有存储过程的sql语句 无 DECLARE @procName VARCHAR(500)DECLARE cur CURSOR FOR SELECT [name] FROM sys.objects WHERE type = 'p'OPEN curFETCH next FROM cur INTO @procNameWHILE @@fetch_status = 0 BEGIN EXEC('drop procedure ' + @procName) FE
删除所有存储过程的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
EXEC('drop procedure ' + @procName)
FETCH next FROM cur INTO @procName
END
CLOSE cur
DEALLOCATE cur 
每个人都需要一台速度更快、更稳定的 PC。随着时间的推移，垃圾文件、旧注册表数据和不必要的后台进程会占用资源并降低性能。幸运的是，许多工具可以让 Windows 保持平稳运行。
Copyright 2014-2025 https://www.php.cn/ All Rights Reserved | php.cn | 湘ICP备2023035733号
414
收藏
