SQL Server 2017

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select v.* --, binary_checksum(a, b), binary_checksum(c,b), binary_checksum(b), checksum(a)
into t1
FROM (VALUES(1, NULL, 100, NULL),
            (2, NULL,    2,   1.0)
     ) v(    id,a,    b,   c);
2 rows affected

select v.* --, binary_checksum(a, b), binary_checksum(c,b), binary_checksum(b), checksum(a)
into t2
FROM (VALUES(1, NULL, 100, NULL),
            (2, 1,    2,   1.0)
     ) v(    id,a,    b,   c);
2 rows affected

select *
from information_schema.columns
where table_name = 't'


TABLE_CATALOG
TABLE_SCHEMA
TABLE_NAME
COLUMN_NAME
ORDINAL_POSITION
COLUMN_DEFAULT
IS_NULLABLE
DATA_TYPE
CHARACTER_MAXIMUM_LENGTH
CHARACTER_OCTET_LENGTH
NUMERIC_PRECISION
NUMERIC_PRECISION_RADIX
NUMERIC_SCALE
DATETIME_PRECISION
CHARACTER_SET_CATALOG
CHARACTER_SET_SCHEMA
CHARACTER_SET_NAME
COLLATION_CATALOG
COLLATION_SCHEMA
COLLATION_NAME
DOMAIN_CATALOG
DOMAIN_SCHEMA
DOMAIN_NAME


select t1.*, binary_checksum(a, b)
from t1


id
a
b
c
(No column name)


1
null
100
null
-109

2
null
2
1.0
-11


select t2.*, binary_checksum(a, b)
from t2


id
a
b
c
(No column name)


1
null
100
null
-109

2
1
2
1.0
18