1
declare @temp varchar(150)
2declare @sql varchar(128)
3
4declare aa cursor for //声明游标
5 select name from sysobjects where type = 'u'order by refdate desc //游标所执行的语句
6open aa 打开游标
7fetch next from aa into @temp //进行循环
8while(@@fetch_status=0) //执行成功为0
9begin
10 set @sql = 'delete from [' + @temp + ']'
11 execute(@sql)
12 fetch next from aa into @temp
13end
14close aa
15deallocate aa
declare @temp varchar(150)2
declare @sql varchar(128)3
4
declare aa cursor for //声明游标5
select name from sysobjects where type = 'u'order by refdate desc //游标所执行的语句6
open aa 打开游标7
fetch next from aa into @temp //进行循环8
while(@@fetch_status=0) //执行成功为09
begin10
set @sql = 'delete from [' + @temp + ']'11
execute(@sql)12
fetch next from aa into @temp13
end14
close aa15
deallocate aa