通過(guò)動(dòng)態(tài)SQL語(yǔ)句創(chuàng)建游標(biāo)

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’;
–創(chuàng)建動(dòng)態(tài)游標(biāo)
set @sql = ‘declare rowCursor cursor For select ‘+@PrimaryKey+’ as PKey , ‘+@FieldName
+’ as DbValue from ‘+@TableName;
EXEC(@sql);
–打開(kāi)游標(biāo)
OPEN rowCursor;
–取值
fetch next from rowCursor into @PKey,@DbValue;
–循環(huán)
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
–關(guān)閉游標(biāo)
close rowCursor;
–釋放游標(biāo)控件
deallocate rowCursor;