Posted on
2006-06-16 21:05joinsky
阅读(191)
评论(0)
编辑收藏举报
1declare@tempvarchar(150) 2declare@sqlvarchar(128) 3 4declare aa cursorfor//声明游标 5select name from sysobjects where type ='u'orderby refdate desc//游标所执行的语句 6open aa 打开游标 7fetchnextfrom aa into@temp//进行循环 8while(@@fetch_status=0) //执行成功为0 9begin 10set@sql='delete from ['+@temp+']' 11execute(@sql) 12fetchnextfrom aa into@temp 13end 14close aa 15deallocate aa 16