Quickly check the consistency of SQL two-table data

1 former words

A new feature is implemented within the project: cloning a database.

2 goals

Cloning is not cloned with SQL Server, so after completion, you need to check the table of some data and the original table consistency. Some of the columns in some tables allow inconsistencies.

3 implementation

The two tables need to check the number of columns out, add each row checksum as the table data characteristics, contrast.

4 Code

DECLARE @col varchar (100) Define a column name that is not needed in order to exclude this column
Set @col = ' '
Select @[email protected]+ ', ' +name from syscolumns where id=object_id (' table ') and name<> ' Revision ' ORDER by colid
Set @col =stuff (@col, 1, 1, ")
EXEC (' Select sum (CAST (checksum (' [email protected]+ ') as bigint) as checksumvalue from table ')

Quickly check the consistency of SQL two-table data