declare @name nvarchar(255),@sql nvarchar(4000)
DECLARE task_cursor CURSOR LOCAL FOR --游标定义
select [name] from sysobjects where type= 'U ' --获取当前数据库中的所有表的表名
OPEN task_cursor --打开游标
FETCH NEXT FROM task_cursor INTO @name
WHILE @@FETCH_STATUS = 0
BEGIN
set @sql = 'delete from '+@name
exec(@sql)
FETCH NEXT FROM task_cursor INTO @name
END
CLOSE task_cursor
DEALLOCATE task_cursor
DECLARE task_cursor CURSOR LOCAL FOR --游标定义
select [name] from sysobjects where type= 'U ' --获取当前数据库中的所有表的表名
OPEN task_cursor --打开游标
FETCH NEXT FROM task_cursor INTO @name
WHILE @@FETCH_STATUS = 0
BEGIN
set @sql = 'delete from '+@name
exec(@sql)
FETCH NEXT FROM task_cursor INTO @name
END
CLOSE task_cursor
DEALLOCATE task_cursor