如何将今天的月份与SQL Server视图中的列名进行比较

DECLARE @currentMonth INT
SET @currentMonth = MONTH(GETDATE())

DECLARE @sqlQuery NVARCHAR(MAX)
SET @sqlQuery = 'SELECT '
SET @sqlQuery = @sqlQuery + CASE WHEN @currentMonth = 1 THEN 'JanuaryColumn'
                                WHEN @currentMonth = 2 THEN 'FebruaryColumn'
                                WHEN @currentMonth = 3 THEN 'MarchColumn'
                                -- Add more cases for other months
                                ELSE 'UnknownColumn' END
SET @sqlQuery = @sqlQuery + ' FROM YourView'

EXEC sp_executesql @sqlQuery