I am trying to modify data in a SQL Server database using the query below. But it fails; why??
update person_course datetimestamp = '10/6/1900 12:00:01 AM' where personid > 470
I get
Server: Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near 'datetimestamp'.You need the key word SET
update person_course SET datetimestamp = '10/6/1900 12:00:01 AM' where personid > 470|||Thanks. I saw it after I had sent the message. Aaarrrgh!!! Long day I guess.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment