[MSSQL] 반복문(WHILE) 예제

-----------구구단--------------

declare @a int, @dan int

set @dan = 2

while @dan < 10

begin

   set @a = 1

   while @a < 10

   begin

      print str(@dan) + ' x ' +str(@a) + ' = ' + str(@dan * @a)

      set @a = @a+1

   end

   print ''

   set @dan = @dan + 1

end 

set @a = 1

print '끝'

[참조] http://j.finfra.com/zbl/?document_srl=3545&mid=lecMsSqlLecdata&sort_index=readed_count&order_type=asc

의 내용을 약간 변경함