引用
declare @name char(7),@sql varchar(500)set @sql='create table test2 ('declare mycursor cursor for
select 名称 from test1 --名称是要成为列的那个字段open mycursorfetch next from mycursor into @namewhile @@fetch_status=0
begin
set @sql=@sql+@name+' char(8),'fetch next from mycursor into @name
endset @sql=substring(@sql,1,len(@sql)-1)+')'exec(@sql)
declare @name char(7),@sql varchar(500)set @sql='create table test2 ('declare mycursor cursor for
select 名称 from test1 --名称是要成为列的那个字段open mycursorfetch next from mycursor into @namewhile @@fetch_status=0
begin
set @sql=@sql+@name+' char(8),'fetch next from mycursor into @name
endset @sql=substring(@sql,1,len(@sql)-1)+')'exec(@sql)
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货