1declare @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
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