select userid into #temp from users order by userid
declare @userid varchar(20)
declare cur cursor for
select userid from #temp
OPEN cur
FETCH NEXT FROM cur INTO @userid
BEGIN
while @@fetch_status <> -1
begin
print @userid
FETCH NEXT FROM cur INTO @userid
end
END
CLOSE cur
DEALLOCATE cur
declare @userid varchar(20)
declare cur cursor for
select userid from #temp
OPEN cur
FETCH NEXT FROM cur INTO @userid
BEGIN
while @@fetch_status <> -1
begin
print @userid
FETCH NEXT FROM cur INTO @userid
end
END
CLOSE cur
DEALLOCATE cur
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货