å¯ä»¥å 对æ°æ®åºä¸ç表æ°æ®è¿è¡æ£åºæåï¼ç¶åæå°ç»æçæ¶åå°printæ¾å¨å¾ªç¯å¤ã
å¦ï¼test表ä¸æå¦ä¸æ°æ®
ç°å¨è¦ç¨æ¸¸æ ååºæåä¸æ¡ï¼ä¹å°±æ¯â5ï¼åä¸âè¿æ¡ã
代ç å¦ä¸ï¼
declare @id int --å®ä¹åé
declare @name varchar(10) --å®ä¹åé
declare cur_c cursor for select * from test order by id --å®ä¹æ¸¸æ
open cur_c --æå¼æ¸¸æ
fetch next from cur_c into @id,@name --å游æ å¼å°åé
while @@fetch_status = 0 --循ç¯éåºæ¡ä»¶
begin --循ç¯å¼å§
fetch next from cur_c into @id,@name --继ç»å游æ å¼å°åé
end --循ç¯ç»æ
print cast(@id as varchar)+','+@name --æå°æåä¸æ¡ç»æ
close cur_c --å
³é游æ
deallocate cur_c --éæ¾æ¸¸æ
ç»æå¦å¾ï¼