declare @n int
select @n=1
while @n<4
begin
insert abc
select a='a'+cast(@n as varchar),b='b'+cast(@n as varchar),c='c'+cast(@n as varchar)
select @n=@n+1
end
select @n=1
while @n<4
begin
insert abc
select a='a'+cast(@n as varchar),b='b'+cast(@n as varchar),c='c'+cast(@n as varchar)
select @n=@n+1
end
USE HRDB
declare @n int
select @n=1
while @n<4
begin
insert aaa
select a='a'+convert(char(2),@n),b='b'+convert(char(2),@n),c='c'+convert(char(2),@n)
select @n=@n+1
end
from
(Select a='a',b='b',c='c') m cross join
(select i = 1+i1.i + i2.i + i3.i + i4.i + i5.i + i6.i
from
(select i = 0 union select 1) as i1 ,
(select i = 0 union select 2) as i2 ,
(select i = 0 union select 4) as i3 ,
(select i = 0 union select 8) as i4 ,
(select i = 0 union select 16) as i5 ,
(select i = 0 union select 32) as i6
) n
Order By n.i