create procedure sp_createtable(
@tname varchar(100) ,
@colscript varchar(1000),
@colnum int ,
@coltype varchar(100) )
as
begin
declare @s varchar(8000),@i int
set @s = 'create table '+@tname+'('+@colscript+')'
exec(@s)
set @i=0
while @i<@colnum
begin
set @i=@i+1
set @s='alter table '+@tname+' add col'+rtrim(@i)+' '+@coltype
exec(@s)
end
end
go
exec sp_createtable 't1','id int,name varchar(20)',8,'varchar(10)'
select * from t1
drop table t1
drop procedure sp_createtable
动态生成列
最新推荐文章于 2023-02-10 17:12:34 发布