declare @i int declare @s varchar(8000) set @s = 'select 1 as id' while @i <1001 begin set @s = @s+','''' as L'+cast(@i as varchar)end exec(@s+' into #') select * from #drop table #
真的要建可以 declare @sql varchar(100) declare @i int create table 表(Id int) set @i=1 while @i<=1000 begin set @sql='alter table 表 add L'+ltrim(@i)+' varchar(20)' exec(@sql) set @i=@i+1 end select * from 表
为何要1000字段, 用两字段定位不行吗 如 create table 表 (no int, --行 col int,--列 val int --值 ) 三字段如何.
declare @s varchar(8000)
set @s = 'select 1 as id'
while @i <1001
begin
set @s = @s+','''' as L'+cast(@i as varchar)end
exec(@s+' into #')
select * from #drop table #
真的要建可以
declare @sql varchar(100)
declare @i int
create table 表(Id int)
set @i=1
while @i<=1000
begin
set @sql='alter table 表 add L'+ltrim(@i)+' varchar(20)'
exec(@sql)
set @i=@i+1
end
select * from 表
用两字段定位不行吗
如 create table 表 (no int, --行
col int,--列
val int --值
)
三字段如何.