用户登陆
站点日历
最新评论
日志搜索
在sql server中关于游标cursor的使用 [ 日期：2009-12-10 ] [ 来自：| 程序代码： | [ 复制代码到剪贴板 ] |
declare @myname varchar(50)
declare @fname varchar(20)
declare @lname varchar(20)
declare my_cursor cursor for
select fname,lname from employee order by emp_id
open my_cursor
fetch next from my_cursor into @fname,@lname
while @@fetch_status=0
begin
set @myname=@fname+@lname
fetch next from my_cursor into @fname,@lname
end
close my_cursor
deallocate my_cursor ......
declare @fname varchar(20)
declare @lname varchar(20)
declare my_cursor cursor for
select fname,lname from employee order by emp_id
open my_cursor
fetch next from my_cursor into @fname,@lname
while @@fetch_status=0
begin
set @myname=@fname+@lname
fetch next from my_cursor into @fname,@lname
end
close my_cursor
deallocate my_cursor ......
暂时没有评论
| 发表评论 - 不要忘了输入验证码哦！ |
