Guest User

Untitled

a guest
Apr 25th, 2018
76
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.56 KB | None | 0 0
  1. SELECT @column_list = COALESCE(@column_list + ', ', '')
  2. + /* Put your casting here from XML, text, etc columns */ QUOTENAME(COLUMN_NAME)
  3. FROM INFORMATION_SCHEMA.COLUMNS
  4. WHERE TABLE_NAME = @table_name
  5. AND TABLE_SCHAME = @schema_name
  6.  
  7. DECLARE @template AS varchar(MAX)
  8. SET @template = 'SELECT CHECKSUM_AGG(CHECKSUM({@column_list})) FROM {@schema_name}.{@table_name}'
  9.  
  10. DECLARE @sql AS varchar(MAX)
  11. SET @sql = REPLACE(REPLACE(REPLACE(
  12. '{@column_list}', @column_list),
  13. '{@schema_name}', @schema_name),
  14. '{@table_name}', @table_name)
  15.  
  16. EXEC ( @sql )
Add Comment
Please, Sign In to add comment