Post reply

VARBINARY not storing the original value

  • February 28, 2019 at 4:49 pm

    #409556

    Hi,
    To identify the changes in the columns, I am using the Hashbytes function and storing the return value in UniqueID column (Varbinary(100)).     
    When I was reading this column it was not showing the original value (data gets truncated).
    Also, I have tried to convert the hashbyte value into Varbinary(100) while inserting it. But no luck.
    Any help would be greatly appreciated...

  • March 1, 2019 at 5:43 am

    #2023282

    What type of column is dbo.TargetData(UniqueID)?

  • March 3, 2019 at 1:09 am

    #2023393

    You would have guessed it correctly. It was my mistake. The column data type was incorrect. I made it to varbinary 100. It's working now. Thanks

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply