declare @sql varchar(1000)
set @sql='select ''今天'' as ['+convert(varchar(10),getdate(),120)+']'
exec (@sql)

------解决方案--------------------
SQL code

select convert(varchar(10), getdate(),120) as [今天]

declare @strSql varchar(1000)
set @strSql = ' select ''今天'' as ['+convert(varchar(10), getdate(),120)+']'
exec (@strSql)