Business Intelligence Question Forum

Do you have questions about SQL Server, Power BI, Azure, or anything else business intelligence related?  You can use this forum to ask technical questions and receive responses from members of the BIDN community.  As you post you gain the permissions to vote up or down, vote on questions or answers and moderate the direction of the forums.

Note: SPAMMING or advertising is strictly prohibited and will result in your account being terminated and your IP address banned. SPAM is taken seriously and is immediately removed by administrators.

Hashbytes

Hi there,

 

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 million rows) it not detect changes
(for example it not detect 7 rows that need to update out of 3 millions)
Is there any limitation for how many columns you can have in hashbytes function?‌‌
Do I need to convert Datetime, Integer and Money to varchar like this

isnull(Convert(nvarchar, TRK_TERM_DT),'NA') + '|'   +
Thanks,
Oded Dror

asked 1 week ago
odeddror2
odeddror

0 Answers

Your Answer

In order to provide an answer to this question, you must Login

I am flagging this question because...




10 inform moderator flags remaining

I am deleting this question because...




I am flagging this answer because...




10 inform moderator flags remaining

Flagging a Post

You have already flagged this post. Clicking "Remove Flag" below will remove your flag, thus reducing the count by one as well.

I am deleting this answer because...