批量删除语句

广告：

DECLARE @tableName NVARCHAR(255)

DECLARE tableCursor CURSOR FOR

select ISBN from num

OPEN tableCursor

FETCH NEXT FROM tableCursor INTO @tableName

WHILE @@FETCH_STATUS = 0

BEGIN

--PRINT @tableName

--exec('dbcc checktable('+@TableName+',repair_allow_data_loss)')

--select * from test where book like '%'+@tableName+'%'

delete from test where book like '%'+@tableName+'%'

FETCH NEXT FROM tableCursor INTO @tableName

END

CLOSE tableCursor

DEALLOCATE tableCursor

广告：