Post reply

Why doesnt the update statement work

  • April 6, 2005 at 11:33 am

    #87187

    If the user test is set to DBO, and you run the update statement in SQL Query Analyzer. Why is the name not being updated? I get "(0 row(s) affected)"

    This for SQL 2000 server

    use test

    update CUSTOMER_DATA

    set first_name = 'test'

    where last_name = 'stien' and customer_id = 777

    Thanks!

  • April 6, 2005 at 11:54 am

    #550883

    The statement worked.  There were no rows that matched the conditions of the WHERE clause.

    Can you SELECT a row with the same WHERE clause?

     

  • April 6, 2005 at 12:39 pm

    #550909

    I see what I am doing wrong, sorry for wasting your time. Thank you!

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply