我的表中有多个列。我需要提取一些列，而不需要在查询中写入列名。
我的表中有多个列。我需要提取一些列，而不需要在查询中写入列名。
提问于 2018-12-06 10:40:23
Select [PPID], [Demand Class_User Data 32] as Demand_Class, [Discipline1] as [Product Group Discipline],
[Net Sales Volume 2015-11], [Net Sales Volume 2015-12], [Net Sales Volume 2016-01], [Net Sales Volume 2016-02], [Net Sales Volume 2016-03],
[Net Sales Volume 2016-04], [Net Sales Volume 2016-05], [Net Sales Volume 2016-06], [Net Sales Volume 2016-07], [Net Sales Volume 2016-08],
[Net Sales Volume 2016-09], [Net Sales Volume 2016-10], [Net Sales Volume 2016-11], [Net Sales Volume 2016-12], [Net Sales Volume 2017-01],
[Net Sales Volume 2017-02], [Net Sales Volume 2017-03], [Net Sales Volume 2017-04], [Net Sales Volume 2017-05], [Net Sales Volume 2017-06],
[Net Sales Volume 2017-07], [Net Sales Volume 2017-08], [Net Sales Volume 2017-09], [Net Sales Volume 2017-10], [Net Sales Volume 2017-11],
[Net Sales Volume 2017-12], [Net Sales Volume 2018-01], [Net Sales Volume 2018-02], [Net Sales Volume 2018-03], [Net Sales Volume 2018-04],
[Net Sales Volume 2018-05], [Net Sales Volume 2018-06], [Net Sales Volume 2018-07], [Net Sales Volume 2018-08], [Net Sales Volume 2018-09],
[Net Sales Volume 2018-10],
[Net Sales Value 2015-11], [Net Sales Value 2015-12], [Net Sales Value 2016-01], [Net Sales Value 2016-02], [Net Sales Value 2016-03],
[Net Sales Value 2016-04], [Net Sales Value 2016-05], [Net Sales Value 2016-06], [Net Sales Value 2016-07], [Net Sales Value 2016-08],
[Net Sales Value 2016-09], [Net Sales Value 2016-10], [Net Sales Value 2016-11], [Net Sales Value 2016-12], [Net Sales Value 2017-01],
[Net Sales Value 2017-02], [Net Sales Value 2017-03], [Net Sales Value 2017-04], [Net Sales Value 2017-05], [Net Sales Value 2017-06],
[Net Sales Value 2017-07], [Net Sales Value 2017-08], [Net Sales Value 2017-09], [Net Sales Value 2017-10], [Net Sales Value 2017-11],
[Net Sales Value 2017-12], [Net Sales Value 2018-01], [Net Sales Value 2018-02], [Net Sales Value 2018-03], [Net Sales Value 2018-04],
[Net Sales Value 2018-05], [Net Sales Value 2018-06], [Net Sales Value 2018-07], [Net Sales Value 2018-08], [Net Sales Value 2018-09],
[Net Sales Value 2018-10]
From [dbo].[Sheet1$] 我需要调用所有的列名，从2018-08年的净销售额开始，而不用写它。我该怎么做。
回答 1
Stack Overflow用户
回答已采纳
发布于 2018-12-06 11:39:26
生成动态SQL并执行生成的语句：
-- Declarations
DECLARE
@stm nvarchar(max),
@err int
-- Statement generation
SELECT @stm = (
SELECT CONCAT(',[', [name], ']')
FROM sys.columns
WHERE
([name] LIKE 'Net Sales Value%') AND
(OBJECT_NAME([object_id]) = 'Sheet1$')
FOR XML PATH('')
)
SELECT @stm = CONCAT(
'Select [PPID], [Demand Class_User Data 32] as Demand_Class, [Discipline1] as [Product Group Discipline]',
@stm,
' From [dbo].[Sheet1$] '
)
-- Execution
EXEC @err = sp_executesql @stm
IF @err = 0
PRINT 'OK'
ELSE
PRINT 'Error'页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/53649544
复制相关文章
相似问题
腾讯云开发者
