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 ,ABS(CHECKSUM(b.av0_style,b.av0_code )) AS chk 27.01.21

https://learn.microsoft.com/en-us/sql/t-sql/functions/checksum-transact-sql?view=sql-server-ver17

• Home
• Notebook
• Contact us

• Privacy Statement
• 

Copyleft ☠ 2025