Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2002
    Location
    Silver Spring, Maryland
    Posts
    74

    Unanswered: Qry: update person_course datetimestamp = '10/6/1900 12:00:01 AM' fails!!!

    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'.

  2. #2
    Join Date
    Dec 2001
    Location
    Toronto, Canada
    Posts
    335
    You need the key word SET

    update person_course SET datetimestamp = '10/6/1900 12:00:01 AM' where personid > 470
    MCDBA

  3. #3
    Join Date
    Feb 2002
    Location
    Silver Spring, Maryland
    Posts
    74
    Thanks. I saw it after I had sent the message. Aaarrrgh!!! Long day I guess.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •