Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Dorffius
Starting Member
36 Posts |
 Posted - 2002-04-23 : 09:04:37
|
| This is the code I am using. For some reason I get an syntax error near the word UNIQUE. By changing certain things such as quotes, I get access errors. I'm not quite sure what the problem is.UPDATE dbo.PLAYERSSET FIRST_NAME = 'BENT1', LAST_NAME = '', COMPANY = '', ADD_LINE1 = '', CLASS = 'EMPLOY', PAID = '0', POSTAL = '', PHONE = '', FAX = '', CLUBRENTAL = '0', GCOURSE = 'Springfield', COURSE = '16A'WHERE UNIQUE = '{5C82CD7B-5168-11D6-A95C-000629394C9A}' |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2002-04-23 : 09:22:33
|
| UNIQUE is a reserved word, and thus, a poor choice for a column name as illustrated by your error. (I am assuming UNIQUE is a name of a column in dbo.Players, otherwise disregard)You should rename the column. You could use [UNIQUE] instead of UNIQUE, but that will only fix the error, not the problem.<O> |
 |
|
|
|
|
|
|
|
Invalid Unique Identifier?