这个题这类写法是错误的 select A as 'XX'+year(getdate()) from table 只能通过参数转换来做 DECLARE @SQL VARCHAR(100) SELECT @SQL ='SELECT A AS xx-'+'year(getdate())FROM table' EXEC (@SQL)
简单:DECLARE @SQL VARCHAR(100) SELECT @SQL ='SELECT A AS xx-'+'year(getdate())FROM table' EXEC (@SQL)
2:估计你也就是为了数据绑定到诸如DataGrid/DataGridView上,那些控件你自己添加colum,分别指定绑定字段和列头文字就行了,不要用自动生成列
select A as 'XX'+year(getdate()) from table 只能通过参数转换来做
DECLARE @SQL VARCHAR(100)
SELECT @SQL ='SELECT A AS xx-'+'year(getdate())FROM table'
EXEC (@SQL)
SELECT @SQL ='SELECT A AS xx-'+'year(getdate())FROM table'
EXEC (@SQL)