删除多表数据
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[DelDataTable]
AS
BEGIN
DECLARE @tablename VARCHAR(80)
DECLARE @cSql VARCHAR(8000)
SET @cSql = ''
DECLARE cur_authors cursor
for
SELECT [name] from sysobjects where [name] like 'T%' and type ='U'
open cur_authors
fetch next from cur_authors into @tablename
while(@@fetch_status=0)
begin
SET @cSql = + 'delete from'+ ' ' + @tablename
EXEC(@cSql)
set @cSql = ''
fetch next from cur_authors into @tablename
end
close cur_authors
deallocate cur_authors
END
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步