|
#2
从小到大2007-04-26 10:51
|
declare @ordnum varchar(20),
declare @orddate datetime,
declare @titleid tid
declare curSales scroll cursor
for
select stor_id,ord_num,,ord_date,title_id
from sales
for read only
open curSales
fetch next from curSales into
@storid ,
@ordnum ,
@orddate,
@titleid
where @@fetch_status=0
begin
print +@storid
print +@ordnum
print +@orddate
print +@titleid
print ''
fetch next from curSales into
@storid ,
@ordnum ,
@orddate,
@titleid
end
close curSales
为什么不能通过呢！我看没有语法错误啊！
这是pubs数据库里的sales表
[此贴子已经被作者于2007-4-26 10:24:28编辑过]