Update e2 set e2.empname=e1.empname from emp2 e2 inner join e

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?

Question Posted / rajesh.a

8 Answers
12420 Views
I also Faced
E-Mail Answers

Answer Posted / 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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the beast way to write CTE in SQL Server ?

1024

Can you roll back the ddl statement in a trigger?

943

What is mscorsvw.exe - process - microsoft .net framework ngen?

937

What are the new data types are introduced in sql 2000?

887

How to change the ownership of a schema in ms sql server?

1162

What are the dmvs?

998

How to disable a login name in ms sql server?

1109

What is bulkcopy in sql?

931

How to change a login name in ms sql server?

1060

Difference between Sql server reporting services and Crystal reports?

168

What is blocking and how would you troubleshoot it? : sql server database administration

1030

When you should use a low fill factor?

978

System requirements for sql server 2005 express edition?

994

What is built-in/administrator?

985

Does partitioning improve performance?

948