Most basic SQL question and I still am making a mistake.

[KAMAZON]

UPDATE MemberDetails
SET
STREET = '45 Upper Road',
City = 'New Town',
State = 'New State',
ZipCode = '99112',
WHERE MemberID = 4;


Server: Msg 156, Level 15, State 1, Line 8
Incorrect syntax near the keyword 'WHERE'.


I have also tried it with:
WHERE MemberID = '4';
WHERE MemberID = 4


with open close parens:
UPDATE MemberDetails
SET
(
STREET = '45 Upper Road',
City = 'New Town',
State = 'New State',
ZipCode = '99112',
WHERE MemberID = 4
);



This is MS SQL 2000 running on my XP pro box. Any suggestions? Thanks.

 

[troytime]

try removing the comma after zipCode = '99112'

 

[Snapster]

extra comma just before the WHERE

ZipCode = '99112', <------- remove

 

[Atheus]

You don't want a comma after the:

ZipCode = '99112'

as you're not continuing the same bit if you know what i mean...

Also - is ZipCode an integer or a string? If it's an int you don't want those quotes around it.

UPDATE MemberDetails
SET
(
STREET = '45 Upper Road',
City = 'New Town',
State = 'New State',
ZipCode = '99112'
WHERE MemberID = 4
);

or

UPDATE MemberDetails
SET
(
STREET = '45 Upper Road',
City = 'New Town',
State = 'New State',
ZipCode = 99112
WHERE MemberID = 4
);

/edit: LOL beaten to it twice

 

[KAMAZON]

Wooohooo, you guys roxors my soxors. Thanks Team Anandtech!

 

[manlymatt83]

Originally posted by: troytime
try removing the comma after zipCode = '99112'

Yep, here's your problem.

 

[Evadman]

In case no one has mentioned it yet, you have an extra comma after the zip code.

 

[yllus]

I believe the answer is to reinstall SQL Server. 😉