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])
)
[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