SQLServer2008下游标的使用
SqlServer下的的SQL语法跟Oracle中的SQL语法还是有很大不同的，这里记录一下在SqlServer下游标的使用方法，以备后用。
declare @str varchar(100),@n varchar(50),@f varchar(3)declare mycursor Cursor Scroll for select name from sys.tablesopen mycursorfetch next from mycursor into @n;while(@@FETCH_STATUS=0)beginset @str = 'drop table ';set @f = SUBSTRING(@n,1,3)if @f <> 'ACL' and @f <> 'BF_'beginset @str = @str + @nexec(@str)endfetch next from mycursor into @n;endclose mycursordeallocate mycursor
