updatestatement

Question

Post reply

updatestatement

kumar99ms

SSCommitted

Points: 1584
More actions
August 27, 2008 at 2:55 am

#71817

Employee table
EmployeeID Employeename Employeecode Passportcode
1 aaaa 087878
2 bbbb 067678
Passport table
EmployeeId passport code
1 02344
2 02343
How can i update this passport code in the employee table
using update statement any body plz help me.

Viewing 8 posts - 1 through 7 (of 7 total)

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

Christopher Stobbs SSC-Insane Points: 21098 More actions · Answer 1

Hi there,

Which version of SQL are you using as I see you have posted this on 2000 and 2005 forums

Please could you remove one of them?

Thanks

Chris

----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley

:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]

SQL-4-Life

ChiragNS One Orange Chip Points: 26137 More actions · Answer 2

Update employee set Passportcode = Passport.Passportcode

From PassPort WHERE Employee.employeeId = PassPort .PassportId.

I suggest you look into BOL and try it out yourself. then if you have doubts ask here. 🙂

"Keep Trying"

kumar99ms SSCommitted Points: 1584 More actions · Answer 3

here we are using two table so we can use join right

karthik M One Orange Chip Points: 29139 More actions · Answer 4

kumar99ms (8/27/2008)
here we are using two table so we can use join right

Yes.

I suggest you look into BOL and try it out yourself. then if you have doubts ask here.

CONCUR...

karthik

ChrisM@Work SSC Guru Points: 186127 More actions · Answer 5

kumar99ms (8/27/2008)
Employee table
EmployeeID Employeename Employeecode Passportcode
1 aaaa 087878
2 bbbb 067678
Passport table
EmployeeId passport code
1 02344
2 02343
How can i update this passport code in the employee table
using update statement any body plz help me.

UPDATE e SET Passportcode = p.Passportcode

FROM Employee e

INNER JOIN Passport p ON p.EmployeeId = e.EmployeeId

^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden

kumar99ms SSCommitted Points: 1584 More actions · Answer 6

i am using the above query any performance issue come in future

ChiragNS One Orange Chip Points: 26137 More actions · Answer 7

How much data is there in your tables and how much more data will be there in the tables in the future.

"Keep Trying"