SELECT id ,av0_style ,SUBSTRING(HASHBYTES('SHA2_256', CONCAT(av0_style,av0_code) ),1,8) AS _hash FROM SL_customer.dbo.av0_style

https://blog.greglow.com/2018/07/02/sql-finding-rows-that-have-changed-in-t-sql-checksum-binary_checksum-hashbytes/

UPDATE t set _hash = CONVERT(NVARCHAR(8),HASHBYTES('SHA2_256', CONCAT(av0_style,av0_code)),2) FROM SL_customer.dbo.av0_style AS t 27.01.21

https://stackoverflow.com/questions/2120/convert-hashbytes-to-varchar

UPDATE t set _hash = CONVERT(NVARCHAR(8),HASHBYTES('SHA2_256', CONCAT( t.av0_style ,t.av0_code )),2) FROM SL_customer.dbo.av0_style AS t WHERE t._hash != CONVERT(NVARCHAR(8),HASHBYTES('SHA2_256', CONCAT( t.av0_style ,t.av0_code )),2) 27.01.21

• Home
• Notebook
• Contact us

• Privacy Statement
• 

Copyleft ☠ 2024