一个简单的游标删除SQL SERVER表

最新推荐文章于 2023-06-20 13:10:04 发布

waterxcfg304

最新推荐文章于 2023-06-20 13:10:04 发布

阅读量4.9k

点赞数 1

分类专栏： SQL - Microsoft 文章标签： SQL SERVER CURSOR

本文链接：https://blog.csdn.net/waterxcfg304/article/details/40457957

版权

SQL - Microsoft 专栏收录该内容

6 篇文章 0 订阅

订阅专栏

use databaseName
declare @tblname char(100)
declare @sql char(5000)
declare table_cursor cursor for select name from sysobjects where name like 'tb_card[_]%' and name<>'Tb_card_regist' and name<>'Tb_card_item' and name<>'Tb_card_discrule' and name<>'tb_card_packagesetdetail' and name<>'tb_card_packagedetail' and name<>'tb_card_exchangeitem'
and name<>'tb_card_package'
open table_cursor

fetch next from table_cursor into @tblname
WHILE @@FETCH_STATUS = 0
BEGIN
set @sql='delete from '+@tblname
exec(@sql)
print 'delete ' +@tblname + 'successful'
fetch next from table_cursor into @tblname
END
close table_cursor
deallocate table_cursor