SQL Server Express - Incorrect Syntax near ','

Question

I am getting an anoying error on this simple sql and I can't spot the error, any help will be appretiated.

CREATE TABLE alertitem 
    ([id] INT, 
     [dateposted] DATETIME, 
     [daterevised] DATETIME, 
     [datestart] DATETIME, 
     [dateexpires] DATETIME, 
     [userid] INT, 
     [title] VARCHAR(MAX), 
     [details] VARCHAR(MAX), 
     [lat] DOUBLE, 
     [lon] DOUBLE, 
     [radius] INT, 
     [imageid] INT);

What represents a double in sql server?

Tim Lehner
– Tim Lehner

2012-03-28 21:17:33 +00:00
Commented Mar 28, 2012 at 21:17 — Tim Lehner
– Tim Lehner, Commented Mar 28, 2012 at 21:17

abatishchev · Accepted Answer · 2012-05-29 11:38:19Z

8

Double isn't a SQL Server datatype.

This should be a complete list of all the data types, see MSDN.

I should note, you'll probably want to use FLOAT or DECIMAL to solve your problem, but I don't know anything about the rest of what you're doing (producers or consumers), so I'll let you pick which data type will solve your problem.

edited May 29, 2012 at 11:38

abatishchev

101k88 gold badges303 silver badges443 bronze badges

answered Mar 28, 2012 at 21:16

WebMasterP

5184 silver badges8 bronze badges

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

1 Comment

user1279144 Over a year ago

It worked, Thanks, I was using the same syntax as MySQL which uses DOUBLE as a data type.

NoAlias · Accepted Answer · 2012-03-28 21:16:33Z

6

Change DOUBLE to FLOAT to fix your problem.

answered Mar 28, 2012 at 21:16

NoAlias

9,2032 gold badges30 silver badges46 bronze badges

Comments

Darren · Accepted Answer · 2012-03-28 21:18:01Z

3

Use decimal(9,2) or the precision you require rather than DOUBLE

answered Mar 28, 2012 at 21:18

Darren

71.2k24 gold badges141 silver badges146 bronze badges

Comments

Michael Capobianco · Accepted Answer · 2012-03-28 21:21:40Z

1

You simply needed to remove DOUBLE, as it's not a supported data type. I'd also reccomend organizing your query in a more easy to read manner such as:

CREATE TABLE alertitem (
    [id] INT,
    [dateposted] DATETIME,
    [daterevised] DATETIME,
    [datestart] DATETIME,
    [dateexpires] DATETIME,
    [userid] INT,
    [title] VARCHAR(MAX),
    [details] VARCHAR(MAX),
    [lat] FLOAT,
    [lon] FLOAT,
    [radius] INT,
    [imageid] INT);

You'll find it easier to troubleshoot bugs this way.

answered Mar 28, 2012 at 21:21

Michael Capobianco

8227 silver badges17 bronze badges

Collectives™ on Stack Overflow

SQL Server Express - Incorrect Syntax near ','

4 Answers 4

1 Comment

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related