大 哥

导航

SQL游标的使用

declare @@testid varchar(40)
declare curTest cursor
for
select R_user from T_Reply
open curTest
fetch next from curTest into @@testid
while(@@fetch_status=0)
select R_id from T_Reply
print @testid
close curTest
Deallocate curTest

posted on 2010-03-06 17:14  VIP-爷  阅读(134)  评论(0)    收藏  举报