Nakul,
I have one question, I'm using SQL server 2016 and I have a table with 150 columns with multiple data types
I implemented hashbytes (SHA1) for Merge statement (Insert / Update)
I notice that sometimes (I have around 3 millions rows) it not detect changes
(for example it not detect 7 rows that need to update out of 3 million)
Is there any limitation for how many columns you can have in hashbytes function?
Thanks,
Oded Dror