批量刪除表，sql server循環(huán)查詢(xún)表數(shù)據(jù)(循環(huán)數(shù)據(jù)庫(kù)中的表記錄游標(biāo)循環(huán)刪除動(dòng)態(tài)表)
發(fā)布時(shí)間：2024/8/3 8:51:52 作者：Admin 閱讀：55
廣告：
DECLARE @tableName NVARCHAR(255)
DECLARE tableCursor CURSOR FOR
select name from sysobjects where name like 'TMP%'
OPEN tableCursor
FETCH NEXT FROM tableCursor INTO @tableName
WHILE @@FETCH_STATUS = 0
BEGIN
--PRINT @tableName
exec('drop table '+ @TableName)
FETCH NEXT FROM tableCursor INTO @tableName
END
CLOSE tableCursor
DEALLOCATE tableCursor
DECLARE @tableName NVARCHAR(255)
DECLARE tableCursor CURSOR FOR
select name from sysobjects where name like 'TMP%' and and OBJECTPROPERTY(id, N'IsUserTable') = 1
OPEN tableCursor
FETCH NEXT FROM tableCursor INTO @tableName
WHILE @@FETCH_STATUS = 0
BEGIN
--PRINT @tableName
exec('dbcc checktable('+@TableName+',repair_allow_data_loss)')
FETCH NEXT FROM tableCursor INTO @tableName
END
CLOSE tableCursor
DEALLOCATE tableCursor
DECLARE @tableName NVARCHAR(255)
DECLARE tableCursor CURSOR FOR
select name from sysobjects where name like 'TMP%' and xtype='U'
OPEN tableCursor
FETCH NEXT FROM tableCursor INTO @tableName
WHILE @@FETCH_STATUS = 0
BEGIN
--PRINT @tableName
exec('dbcc checktable('+@TableName+',repair_allow_data_loss)')
FETCH NEXT FROM tableCursor INTO @tableName
END
CLOSE tableCursor
DEALLOCATE tableCursor
廣告：
相關(guān)文章
