34,590
社区成员
发帖
与我相关
我的任务
分享
declare @tb table(id int identity(1,1), col nvarchar(10),col2 nvarchar(10),col3 nvarchar(10))
declare @i int, @icount int
declare @str nvarchar(10)
set @i =1
insert into @tb
select 'col','col2','col3'
union all select 'col11','col12','col13'
union all select 'col111','col112','col113'
union all select 'col1111','col1112','col1113'
union all select 'col11111','col11112','col11113'
select @icount = max(id) from @tb
while (@i<=@icount)
begin
set @str =''
select @str = col from @tb where id = @i
print ' --> '+ @str
set @i = @i + 1
end