sql server - checksum accepted result -


i calculating checksum in stored procedure :

checksum_agg(checksum(cid,tableid, sid, pid, vid, tablename, columnkey, columnvalue))  #fdata  

but when @fdata has these data:

1052 2 100 100008 vis0 form.pan_elig 4401001 1

1052 2 100 100008 vis0 form.pan_elig 4401002 1

1052 2 100 100008 vis0 form.pan_elig 4401004 0

1052 2 100 100008 vis0 form.pan_elig 4401005 0

1052 2 100 100008 vis0 form.pan_elig null null

1052 2 100 100008 vis0 form.pan_elig null null

the result 512. valid checksum?

because when @fdata has data like:

1064 2 100 100002 vis1 form.agg_demog 4502001 agge

1064 2 100 100002 vis1 form.agg_demog 4502003 0

1064 2 100 100002 vis1 form.agg_demog 4502006 0

the result this: -785679630


Comments

Popular posts from this blog

php - Vagrant up error - Uncaught Reflection Exception: Class DOMDocument does not exist -

vue.js - Create hooks for automated testing -

Add new key value to json node in java -