选择值并放置为/别名变量名称？

Question

根据下面的示例，我需要根据变量值自定义标题列名。有办法这样做吗？谢谢。

DECLARE @date DATE
SET @date = '2020-10-2'

DECLARE @monthperYear DECIMAL
SET @monthperYear =  (SELECT ((cast (month(@date) as INT) / 12.0) * 100))

DECLARE @yearBefore INT
SET @yearBefore = (SELECT (year(@date) -1))

DECLARE @percentageheadername VARCHAR (30)
SET @percentageheadername =(SELECT CAST (@monthperYear as varchar(5))+ '% Full Year ' + CAST (@yearBefore as CHAR (5)) +'Actual' as percentageHeadername)



Create Table #sample
(
name varchar (50)
, percentage DECIMAL (10,2)
)

INSERT INTO #sample
(name, percentage)
VALUES
('Marcus', '8'), ('John', '70')

select name, **percentage as @percentageheadername** from #sample
DROP TABLE #sample

Answer 1

可以使用动态sql。

set @percentageheadername = 'SomeName'
set @sqlCommand = 'select name, percentage as ' + @percentageheadername + ' from #sample'

EXEC (@sqlCommand)