Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2008
    Posts
    11

    Unanswered: multiple col updation

    hi,

    I want to update 3 col. of a row in the same table.
    i was tryn n write like this

    update hd_EquipBackUp
    set(Activity_Crd_Out, Eng_Name,Return_Date)=
    ('31','abc','8/9/2009'

    but its giving error like this

    Server: Msg 170, Level 15, State 1, Line 2
    Line 2: Incorrect syntax near '('.

  2. #2
    Join Date
    Sep 2003
    Location
    Vietnam
    Posts
    10

    re:multiple column updating

    Hi,

    You have using sql command with invalid syntax:

    the updating in sql statement :

    update [tablename] set col1 = values, col2 = value2, ...

  3. #3
    Join Date
    Jan 2004
    Posts
    164
    Your update statement should look like this:

    update hd_EquipBackUp
    set Activity_Crd_Out = '31',
    Eng_Name = 'abc',
    Return_Date = '8/9/2009'

  4. #4
    Join Date
    Jan 2008
    Posts
    11
    yes i was mistaking thanks for ur kind replies,

Posting Permissions

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