34,576
社区成员
发帖
与我相关
我的任务
分享
declare @tb table
(
subject nvarchar(100)
)
insert into @tb
select N'语文' union all
select N'数学'
declare @subjectset nvarchar(2000)
set @subjectset = 'create table Table2( '
select @subjectset = @subjectset + subject + ' nvarchar(100),' from @tb
set @subjectset = left(@subjectset,len(@subjectset)-1) + ' )'
exec( @subjectset)
select * from Table2
if object_id('tb')is not null drop table tb
go
create table tb(subject varchar(5))
insert tb select
'语文' union all select
'数学'
declare @s varchar(400)
set @s='create table tt('
select @s=@s+subject+' int,' from tb
set @s=left(@s,len(@s)-1)+')'
print @s
exec(@s)
----------- 结果------------
create table tt(语文 int,数学 int)