中科新闻网苍鹰是几期:powerbuilder 游标问题。
来源：百度文库 编辑：中科新闻网 时间：2024/05/02 01:15:06
declarce cur1 cursor for
code.....;
我想要使Code部分为动态的，即一个字符串内含SQL语句，如何实现？
我测试过：
declarce cur1 cursor for
execute immediate :code;
这么不成，谁有好办法？谢谢！
我自答吧，望对大家有帮助：
string sql = "select " + FieldLst + "From myData"
Declare c1 Dynamic Cursor From SQLSA;
Prepare SQLSA From :sql;
Open Dyanmic c1;
Fetch c1 into : var ;
...........
code.....;
我想要使Code部分为动态的，即一个字符串内含SQL语句，如何实现？
我测试过：
declarce cur1 cursor for
execute immediate :code;
这么不成，谁有好办法？谢谢！
我自答吧，望对大家有帮助：
string sql = "select " + FieldLst + "From myData"
Declare c1 Dynamic Cursor From SQLSA;
Prepare SQLSA From :sql;
Open Dyanmic c1;
Fetch c1 into : var ;
...........
use student
declare @sno char(4),@score smallint
declare cur_sc cursor
for select sno,score from sc
for update of score
open cur_sc
fetch next from cur_sc into @sno,@score
while @@fetch_status=0
begin
if @sno='1001'
update sc set score=score-5
where current of cur_sc
fetch next from cur_sc into @sno,@score
end
close cur_sc
deallocate cur_sc
go