Post
원문 보기 →처음 사용해본 sql loop query
declare @loopcnt int;declare @curcnt int; declare @param1 varchar(20)declare @param2 varchar(20) set @loopcnt = (select count(*) from loop_this_table)set @curcnt = 0; while(@curcnt < @loopcnt) begin set @curcnt = @curcnt +1; select @param 1= i_need_this_collumn, @param2 = i_need_this_column_too from there_is_something_in_this_table insert into put_to_this_table select * from there_is_so
