SQL Server How to select both column and values in SQL query [closed]

snvhrwxg 于 2023-03-11 发布在其他

关注(0)|答案(1)|浏览(199)

Closed. This question needs details or clarity . It is not currently accepting answers.

Want to improve this question? Add details and clarify the problem by editing this post .

I want to select both column names and values in a SQL query.

Here is what I have tried but this query only selects column name:

SELECT name 
FROM sys.columns 
WHERE object_id = OBJECT_ID('Table')

1条答案

To get the values from the columns you need to execute a query that is the result from this:

SELECT CONCAT('SELECT ',STRING_AGG( name,','),' FROM Table') 
FROM sys.columns 
WHERE object_id = OBJECT_ID('Table')

How to execute this statement, in for example a stored procedure, can be found on stackoverflow, for example here: How can I create a dynamic Select statement