Post reply

update multiple columns

  • May 21, 2008 at 1:47 pm

    #191355

    How can i update multiple columns in table Emp(EmpID,EmpName,EmpTItle,JOd Role,JodId,EMpPay) where empid=?

  • May 21, 2008 at 1:51 pm

    #818851

    You mean - something like this?

    update emp

    set empname='Bob Smoot',

    EmpTitle='Emperor',

    Emprole='Master Bottle Washer inspector'

    where

    Empid=12334

    ----------------------------------------------------------------------------------
    Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?

  • May 21, 2008 at 2:29 pm

    #818868

    I am trying to do this in my OLE DN COmmand of SSIS package.

    How can i?

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

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