I work on SQL server 2014 I face issue
but I don't know how to solve it
I need to add columns header as first row on table
I Try as below but i get error
Msg 213, Level 16, State 1, Line 1
Column name or number of supplied values does not match table definition.
Expected result as below :
PartID |
Code |
CodeTypeID |
RevisionID |
ZPLID |
ConCount |
FeatureName |
FeatureValue |
2020 |
ab5060 |
877491 |
26553312 |
4125 |
10 |
Heat |
IC |
what i have tried
CREATE TABLE #AllData
(PartID INT,
Code VARCHAR(20),
CodeTypeID INT,
RevisionID BIGINT,
ZPLID INT,
ConCount INT,
FeatureName nvarchar(500),
FeatureValue nvarchar(500))
insert into #AllData VALUES(2020,'ab5060',877491,26553312,4125,10,'Heat','IC')
insert into #AllData
SELECT STUFF((SELECT ',' + CAST(name AS VARCHAR(50))FROM (SELECT nameFROM tempdb.sys.columns
WHERE [object_id] = OBJECT_ID(N'tempdb..#AllData')) kFOR XML PATH('')), 1, 1, '')SELECT * FROM #AllData