Consulta Nombre y valor de la columna

[Libras]

Código SQL:

DECLARE @COLUMN VARCHAR(MAX)
DECLARE @query VARCHAR(MAX)
 
SELECT @COLUMN=COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS 
WHERE TABLE_NAME='table_name'
 
SET @query='select ' + @COLUMN + ' from table_name'
EXEC (@query)
 

saludos!