不错呦!smile@林凯西,确保“准备文件”中的几个文件都有安装,S...您好,看了您这篇帖子觉得很有帮助。但是有个问题想请...我的修改过了怎么还被恶意注册呢 @jjjjiiii 用PJ快9年了,主要是A...PJ3啊,貌似很少有人用PJ了,现在不是WP就是z...@332347365,我当时接入时错误码没有-10...楼主,ChkValue值应为-103是什么意思呢?...大哥 你最近能看到我发的信息,请跟我联系,我有个制...
MSSQL存储过程中获取记录集并循环操作一例
编辑:dnawo 日期:2008-03-11
复制内容到剪贴板
程序代码

Create PROCEDURE my_sql
AS
declare @id int,@loginname varchar(20),@website varchar(100)
declare rs cursor for select top 50 id,loginname,website from union_user
open rs
fetch next from rs
into @id,@loginname,@website
while @@fetch_status=0
begin
print convert(varchar,@id) + ',' + convert(varchar,@loginname) + ',' + convert(varchar,@website)
fetch next from rs
into @id,@loginname,@website
end
close rs
deallocate rs
GO
AS
declare @id int,@loginname varchar(20),@website varchar(100)
declare rs cursor for select top 50 id,loginname,website from union_user
open rs
fetch next from rs
into @id,@loginname,@website
while @@fetch_status=0
begin
print convert(varchar,@id) + ',' + convert(varchar,@loginname) + ',' + convert(varchar,@website)
fetch next from rs
into @id,@loginname,@website
end
close rs
deallocate rs
GO






评论: 0 | 引用: 0 | 查看次数: 5580
发表评论
请登录后再发表评论!