the problem when I am trying to create a new query, it gives me a red error and says syntax error where is the first parenthesis { are and the INT values of (1,1) and (50) with NVARCHAR and also GETDATE() parenthesis and the ID ([ID] ASC)

CREATE TABLE [dbo].[Cart]
{

      [ID] INT IDENTITY (**1**,1) NOT NULL,
      [CLientID] NVARCHAR (**50**) NOT NULL,
      [ProductID] INT NOTNULL,
      [Amount] INT NOTNULL,
      [DatePurchased] DATETIME DEFAULT GETDATE**()**,
      [IsInCart] BIT NOTNULL,
      CONSTRAINT [PK_Purchase] PRIMARY KEY CLUSTERED ([**ID**] ASC)
}

Related posts

Recent Viewed