mysql删除脏数据_游标删除多个表里脏数据的方法

第一种方法：

代码如下:

CREATE proc [dbo].[delAllRecord]

as

declare @tableName nvarchar(255)

declare @Sql nvarchar(255)

Declare curTable Cursor

for select Table_Name from information_schema.tables where TABLE_TYPE=’BASE TABLE’

Open curTable

Fetch Next From curTable Into @tableName

WHILE(@@FETCH_STATUS = 0)

BEGIN

set @Sql = N’delete from ‘+@tableName

exec sp_executesql @sql

Fetch Next From curTable Into @tableName

end

CLOSE curTable

DEALLOCATE curTable

第二种方法：

代码如下:

–declare test_cursor cursor scroll for

–select id,table_name from dbo.section_type

–open test_cursor

–declare @id int

–declare @table_name nvarchar(50)

–while @@fetch_status=0

–begin