Skip to content

Instantly share code, notes, and snippets.

@mukarramjavid

mukarramjavid/create_condition_using_sql_server_table_fields.sql

Last active March 24, 2023 07:19
Show Gist options
  • Save mukarramjavid/ad7a5fb1ea2323f8a8084e70da47e4a2 to your computer and use it in GitHub Desktop.
Save mukarramjavid/ad7a5fb1ea2323f8a8084e70da47e4a2 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
create_condition_using_sql_server_table_fields.sql
SELECT CONCAT('|| oldValue.', COLUMN_NAME, ' != ', 'newValue.', COLUMN_NAME) AS dataType
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