原句:
=======
declare cro_fastread cursor scroll
for
select sID from PPOK_House order by sID desc
open cro_fastread
=========
我要让
select sID from PPOK_House order by sID desc
[email protected]_SQLWhere这个条件。
注意前后语句
正确通过立即给分。分只能给准确的朋友。谢谢。
------解决方案--------------------
declare @sql varchar(8000)
set @sql= 'declare cro_fastread cursor scroll '
set @[email protected]+ 'for '
set @[email protected]+ 'select sID from PPOK_House '[email protected]_SQLWhere+ 'order by sID desc '
set @[email protected]+ 'open cro_fastread '
set @[email protected]+ '接下来的sql语句 '
exec(@sql)
------解决方案--------------------
不用象楼上那么麻烦,游标是允许在EXEC()中动态创建后再引用的,这一点与变量不同.这样试试:
......
--就是从这儿开始的。
EXEC( 'declare cro_fastread cursor scroll for
select sID from PPOK_House order by sID desc ')
open cro_fastread
......