update multiple columns

Question

Post reply

update multiple columns

Mike Levan

SSChampion

Points: 14201
More actions
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=?

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

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

Matt Miller (4) SSC Guru Points: 124210 More actions · Answer 1

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?

Mike Levan SSChampion Points: 14201 More actions · Answer 2

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

How can i?

update multiple columns

Cookies on SQLServerCentral