what is wrong with my create table SQL?
- by George2
Hello everyone,
I am using SQL Server 2008 management studio to execute the following SQL statements, and here is the related error message from SQL Server management studio. Any ideas what is wrong?
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
Create TABLE [dbo].[BatchStatus](
[BatchID] [uniqueidentifier] NOT NULL CONSTRAINT [PK_BatchStatus_ID],
[BatchStatus] [int] NULL,
CONSTRAINT [PK_BatchStatus_ID] PRIMARY KEY CLUSTERED
(
[BatchID] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
Msg 102, Level 15, State 1, Line 3
Incorrect syntax near ','.
Msg 319, Level 15, State 1, Line 8
Incorrect syntax near the keyword 'with'. If this statement is a common table
expression, an xmlnamespaces clause or a change tracking context clause, the
previous statement must be terminated with a semicolon.
thanks in advance,
George
