Incorrect syntax near ','

Question

I get the following error from the SQL Script I am trying to run:

Msg 102, Level 15, State 1, Line 10 Incorrect syntax near ','.

This is the SQL script:

IF NOT EXISTS (SELECT * 
                 FROM dbo.sysobjects 
                WHERE id = OBJECT_ID(N'[dbo].HDDB_DataSource]') 
                  AND OBJECTPROPERTY(id, N'IsUserTable') = 1)
BEGIN
CREATE TABLE [dbo].[HDDB_DataSource](
 [ID] [int] IDENTITY(1,1) NOT NULL,
 [Name] [nvarchar](255) NOT NULL,
 [Type] [nvarchar](50) NOT NULL,
 [XmlFileName] [nvarchar](255) NULL,
 [ConnectionString] [nvarchar](255) NULL),
 CONSTRAINT [PK_DataSource] PRIMARY KEY CLUSTERED 
(
 [ID] ASC
) ON [PRIMARY]
) ON [PRIMARY]
END

I am using SQL Server 2005.

user253984 · Accepted Answer · 2010-03-18 13:03:49Z

8

Remove the ")" in "[ConnectionString] nvarchar NULL),"

answered Mar 18, 2010 at 13:03

user253984

Sign up to request clarification or add additional context in comments.

1 Comment

KM. Over a year ago

+1 you can paste the OP's code into SSMS and click on the "parse" check icon on the toolbar and get the error message. If you remove the ")" as described in this answer, and repeat the "parse" (or actually run it and create the table) the error goes away and the code runs.

Rob Packwood · Accepted Answer · 2010-03-18 13:04:41Z

3

Get rid of the close paren at the end of the ConnectionString column line before the comma and it should work

answered Mar 18, 2010 at 13:04

Rob Packwood

3,8485 gold badges36 silver badges50 bronze badges

Comments

Community · Accepted Answer · 2013-07-30 22:25:25Z

3

Do you see the extraneous ) at the end of this line?

 [ConnectionString] [nvarchar](255) NULL),

edited Jul 30, 2013 at 22:25

CommunityBot

11 silver badge

answered Mar 18, 2010 at 13:06

mjv

75.7k14 gold badges119 silver badges158 bronze badges

Comments

Rob Osborne · Accepted Answer · 2010-03-18 13:03:40Z

2

You appear to have duplicate lines here:

) ON [PRIMARY]
) ON [PRIMARY]

so the braces are not balanced.

answered Mar 18, 2010 at 13:03

Rob Osborne

5,0254 gold badges35 silver badges43 bronze badges

1 Comment

user121301 Over a year ago

They're not duplicates nor a syntax error. First one is filegroup for the primary key and second is the filegroup for the table.

Guffa · Accepted Answer · 2010-03-18 13:05:19Z

2

Remove ), after the last field (before the constraint).

answered Mar 18, 2010 at 13:05

Guffa

703k111 gold badges760 silver badges1k bronze badges

Comments

Gabe · Accepted Answer · 2010-03-18 13:04:48Z

1

Duplicates

) ON [PRIMARY]
) ON [PRIMARY]

answered Mar 18, 2010 at 13:04

Gabe

50.6k29 gold badges147 silver badges182 bronze badges

1 Comment

user121301 Over a year ago

They're not duplicates nor a syntax error. First one is filegroup for the primary key and second is the filegroup for the table.

Nakul Chaudhary · Accepted Answer · 2010-03-18 13:07:05Z

0

Remove , from last row [ConnectionString] nvarchar NULL),

answered Mar 18, 2010 at 13:07

Nakul Chaudhary

26.2k15 gold badges47 silver badges49 bronze badges

Collectives™ on Stack Overflow

Incorrect syntax near ','

7 Answers 7

1 Comment

Comments

Comments

1 Comment

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

7 Answers 7

1 Comment

Comments

Comments

1 Comment

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related