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 :
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