Tuesday, 16 June 2015

Creating Hash bytes on Sql server table

CREATE TABLE [dbo].[ITEM](

[ITEMID] int IDENTITY(1,1) NOT NULL,

[NAME] nvarchar(50) NOT NULL,

[DESCRIPTION] nvarchar(200) NOT NULL,

[OrderDate] date DEFAULT GETDATE(),

[HASH] varchar(200) Default hashbytes('SHA2_256',[NAME]+ '|' +[DESCRIPTION])

)

No comments:

Post a Comment