declare @Str varchar(1000)
declare @Sql1 varchar(1000)
declare @Sql2 varchar(1000)
set @Str='语文,数学,英语'
set @Sql1=right(replace(','+ @Str ,',',''' union select '''),len(replace(','+ @Str,',',''' union select '''))-9)+''''
set @Sql2='select ' + replace(''''+ @Str + '''',',',''',''')
exec(@Sql1)