SELECT  1 as col1, 2 as col2, 3 as col3, 4 AS col4

name

SELECT  1 as col1, 2 as col2, 3 as col3, 4 AS col4

DECLARE f_cursor CURSOR FOR
SELECT  1 as col1, 2 as col2, 3 as col3, 4 AS col4

OPEN f_cursor;
FETCH NEXT FROM f_cursor;

SELECT reference_name, 
		cursor_name, cursor_scope,
		status, model, concurrency, scrollable,
		open_status, cursor_rows, fetch_status,
		column_count, row_count, last_operation,
		cursor_handle
FROM sys.syscursorrefs scr, sys.syscursors sc
WHERE scr.cursor_handl = sc.cursor_handle
				
CLOSE f_cursor;
DEALLOCATE f_cursor;

нужен такой результат:
name
1
2
3
4

SELECT  1 as col1, 2 as col2, 3 as col3, 4 AS col4
into #tmp

SELECT	name
FROM	tempdb.sys.columns
WHERE	object_id = OBJECT_ID('tempdb..#tmp')

select u.[name], [column]
from
  (SELECT  1 as col1, 2 as col2, 3 as col3, 4 AS col4) p
unpivot ([name] for [column] in (col1, col2, col3, col4)) as u 

declare @xml xml=(select * from (SELECT  1 as col1, 2 as col2, 3 as col3, 4 AS col4) p for xml raw, elements)

select 
	 t.c.value('local-name(.)', 'varchar(50)') as field
	,t.c.value('./text()[1]', 'varchar(50)') as value
from @xml.nodes('/row/*') as t(c)

declare @xml xml;
SET @xml = select * from (SELECT  1 as col1, 2 as col2, 3 as col3, 4 AS col4) p for xml raw, elements;

select 
	 t.c.value('local-name(.)', 'varchar(50)') as field
	,t.c.value('./text()[1]', 'varchar(50)') as value
from @xml.nodes('/row/*') as t(c)

if object_id('tempdb..dddd') is not null drop table tempdb..dddd

SELECT  1 as col1, 2 as col2, 3 as col3, 4 AS col4
into tempdb..dddd

select name
from tempdb.sys.columns
where object_id in
(
select object_id
from tempdb.sys.objects
where name = 'dddd'
)

DECLARE @xml XML;
SET @xml = ( 
SELECT *
FROM   (
           SELECT 1  AS col1,
                  2  AS col2,
                  3  AS col3,
                  4  AS col4
       ) p FOR XML RAW,
       ELEMENTS);

SELECT t.c.value('local-name(.)', 'varchar(50)') AS field,
       t.c.value('./text()[1]', 'varchar(50)') AS VALUE
FROM   @xml.nodes('/row/*') AS t(c)