Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT @column_list = COALESCE(@column_list + ', ', '')
- + /* Put your casting here from XML, text, etc columns */ QUOTENAME(COLUMN_NAME)
- FROM INFORMATION_SCHEMA.COLUMNS
- WHERE TABLE_NAME = @table_name
- AND TABLE_SCHAME = @schema_name
- DECLARE @template AS varchar(MAX)
- SET @template = 'SELECT CHECKSUM_AGG(CHECKSUM({@column_list})) FROM {@schema_name}.{@table_name}'
- DECLARE @sql AS varchar(MAX)
- SET @sql = REPLACE(REPLACE(REPLACE(
- '{@column_list}', @column_list),
- '{@schema_name}', @schema_name),
- '{@table_name}', @table_name)
- EXEC ( @sql )
Add Comment
Please, Sign In to add comment