mukarramjavid/comma_separeted_col_names.sql

Last active March 24, 2023 06:55

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/mukarramjavid/3d5eb921dd159e0835f12d7ca10330b7.js"></script>
Save mukarramjavid/3d5eb921dd159e0835f12d7ca10330b7 to your computer and use it in GitHub Desktop.

Download ZIP

From this query you can get comma separated column names in sql server

Raw

comma_separeted_col_names.sql

	SELECT STRING_AGG(COLUMN_NAME,',') AS ColNames
	FROM INFORMATION_SCHEMA.COLUMNS
	WHERE TABLE_NAME = N'[table_name]'

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment