通过动态SQL语句创建游标

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32

DECLARE @sql varchar(100); DECLARE @TableName varchar(32); DECLARE @FieldName varchar(32); DECLARE @PrimaryKey varchar(32); DECLARE @DbValue varchar(32); DECLARE @PKey int;   --赋值 set @TableName='Student'; SET @FieldName='Name'; SET @PrimaryKey='Id'; --创建动态游标 set @sql = 'declare rowCursor cursor For select '+@PrimaryKey+' as PKey , '+@FieldName +' as DbValue from '+@TableName; EXEC(@sql);   --打开游标 OPEN rowCursor;  --取值 fetch next from rowCursor into @PKey,@DbValue; --循环 while(@@FETCH_STATUS=0)     begin         declare @ExecSql varchar(100);         set @ExecSql='Update '+@TableName +' set '+@FieldName+' = 234324324';         PRINT @ExecSql         EXEC(@ExecSql)         fetch next from rowCursor into @PKey,@DbValue;     end  --关闭游标 close rowCursor; --释放游标控件 deallocate rowCursor;