write down the sql query?
Table Name : emp1
empid empname
1 bala
2 guna
Table Name : emp2
empid empname
1 <Null>
2 <Null>
Solution : emp1 names are updated in emp2, write a query?
Answers were Sorted based on User's Feedback
Answer / dhana
update e2 set e2.empname = e1.empname
from emp2 e2,emp1 e1
where e1.empid = e2.empid
Is This Answer Correct ? | 8 Yes | 1 No |
Answer / vidya
update emp2 set empname =e.empname from emp1 e where
e.empid =emp2.empid
Is This Answer Correct ? | 1 Yes | 1 No |
Answer / a
Update emp2 set empname = (Select empName from emp1 where
emp2.empid =emp1.empid)
Is This Answer Correct ? | 2 Yes | 2 No |
Answer / vicky
update emp2 e2 set e2.empname = (select e1.empname from
emp1 e1 where e2.empid=e1.empid)
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / saravanan
update w set w.ename=q.ename from empn1 w,
(select e.ename,e.empid from empn e,empn1 a where
a.empid=e.empid) q where w.empid=q.empid
Is This Answer Correct ? | 0 Yes | 1 No |
Answer / rajesh.a
Update e2
set e2.empname=e1.empname
from
emp2 e2 inner join emp1 e1 on e1.empid=e2.empid
Is This Answer Correct ? | 0 Yes | 1 No |
Answer / pradip jain
update e2
set e2.name= e1.name
from emp2 e2
join emp1 e1 on e1.id=e2.id
Is This Answer Correct ? | 0 Yes | 1 No |
What is dbcc command in sql server?
What are the steps to follow to configure SQL*Net?
What is the sql server agent?
what is a deadlock? : Sql server database administration
what is memory-optimized nonclustered indexes
What are types of scd? : sql server analysis services, ssas
How do I find the sql server database version?
Scalability, Availability, Integration with internet, etc.)?
Do you know what are the differences between lost updates and uncommitted dependencies?
Why use stored procedures in sql server?
Hi..here i would like to know the Backup and Restore models?
how do we insert 100 records at a time in a table without using for loop in database