How to add top 1 row as header on SQL server as extra row?

Transact-SQL
, ,
7

thanks for support it solved

drop table if exists #AllData
    
 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')
    
 SELECT * FROM #AllData
    
 declare @s varchar(max) = ''
    
 set @s =
     concat( 
     'select ',
         STUFF((
             SELECT ',' + quotename(name)
                 FROM tempdb.sys.columns
                 WHERE [object_id] = OBJECT_ID(N'tempdb..#AllData')
             FOR XML PATH('')
             ), 1, 1, ''),
     ' from ( select ',
         STUFF((
             SELECT ',' + cast(quotename(name, '''') AS VARCHAR(50)) + ' as ' + quotename(name)
                 FROM tempdb.sys.columns
                 WHERE [object_id] = OBJECT_ID(N'tempdb..#AllData')
             FOR XML PATH('')
             ), 1, 1, ''),
         ', g=0 union all select ',
         STUFF((
             SELECT ',cast(' + quotename(name) + ' AS VARCHAR(50))'
                 FROM tempdb.sys.columns
                 WHERE [object_id] = OBJECT_ID(N'tempdb..#AllData')
             FOR XML PATH('')
             ), 1, 1, ''),
         ', g=1 from tempdb..#AllData) t order by g' )
    
 print @s
    
 exec (@s)