动态添加列

declare @i int,@tt nvarchar(20)
 create table #tbl(id nvarchar(20))
 while CHARINDEX(',',@strcourse)>0
 begin
  set @i=CHARINDEX(',',@strcourse) set @tt=SUBSTRING(@strcourse,1,@i-1)
  if not exists(select name from syscolumns where id=object_id('#tbl') and name=@tt)
  exec('alter table #tbl add ['+@tt+'] decimal(5,1)')
  set @strcourse=SUBSTRING(@strcourse,@i+1,LEN(@strcourse)-@i)
 end
 select * from #tbl