Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Save mukarramjavid/68e1cd263f1f3598c02c39828b936b1a to your computer and use it in GitHub Desktop.
Save mukarramjavid/68e1cd263f1f3598c02c39828b936b1a to your computer and use it in GitHub Desktop.
SELECT
CONCAT(COLUMN_NAME, ' = x.', COLUMN_NAME,',' ) AS [type]
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = N'[table]'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment