-- À̸§, ¸Þ¸ð º¯¼ö ¼±¾ð DECLARE @NAME NVARCHAR(50) DECLARE @MEMO NVARCHAR(50) -- Ä¿¼­ ¼±¾ð DECLARE FRIEND_CURSOR CURSOR FOR SELECT NAME, MEMO FROM TB_FRIEND -- Ä¿¼­ ¿­±â OPEN FRIEND_CURSOR -- Ä¿¼­¿¡¼­ µ¥ÀÌÅÍ °¡Á®¿À±â (¹Ýº¹) FETCH NEXT FROM FRIEND_CURSOR INTO @NAME, @MEMO -- µ¥ÀÌÅÍ Ã³¸® (¹Ýº¹) WHILE(@@FETCH_STATUS = 0) BEGIN SELECT @NAME, @MEMO FETCH NEXT FROM FRIEND_CURSOR INTO @NAME, @MEMO END -- Ä¿¼­ ´Ý±â CLOSE FRIEND_CURSOR -- ÇØÁ¦ DEALLOCATE FRIEND_CURSOR GO