/*go
--列数太多 超出varchar(8000)的范围
declare @i int
set @i=0
declare @sql varchar(8000)
set @sql='create table s1('
while @i<600
begin
set @sql=@sql+'v'+cast(@i as varchar(3))+' float,'
set @i=@i+1
end
set @sql=@sql+'v600'+' float)'
print @sql
exec(@sql)
go
declare @v varchar(5)
declare @i int
declare @sql varchar(8000)
set @i=736
while @i<960
begin
set @v='v'+cast(@i as varchar(3))
set @sql= 'alter table s1 add '+@v+' float'
print @sql
set @i=@i+1
end
go
--下面是添加剩下的列
go
declare @v varchar(5)
declare @i int
declare @sql varchar(8000)
set @i=601
while @i<960
begin
set @v='v'+cast(@i as varchar(3))
set @sql= 'alter table s1 add '+@v+' float'
exec(@sql)
print @sql
set @i=@i+1
end
--列数太多 超出varchar(8000)的范围
declare @i int
set @i=0
declare @sql varchar(8000)
set @sql='create table s1('
while @i<600
begin
set @sql=@sql+'v'+cast(@i as varchar(3))+' float,'
set @i=@i+1
end
set @sql=@sql+'v600'+' float)'
print @sql
exec(@sql)
go
declare @v varchar(5)
declare @i int
declare @sql varchar(8000)
set @i=736
while @i<960
begin
set @v='v'+cast(@i as varchar(3))
set @sql= 'alter table s1 add '+@v+' float'
print @sql
set @i=@i+1
end
go
--下面是添加剩下的列
go
declare @v varchar(5)
declare @i int
declare @sql varchar(8000)
set @i=601
while @i<960
begin
set @v='v'+cast(@i as varchar(3))
set @sql= 'alter table s1 add '+@v+' float'
exec(@sql)
print @sql
set @i=@i+1
end