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
12557 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 scan table/view and seek table/view when its occurs? : sql server database administration

1063

What is multi-statement table-value user-defined function?

1003

How to encrypt Strored Procedure in SQL SERVER?

1175

What is the sql server agent?

1098

What is similarity and difference between truncate and delete in sql?

1107

What is the exact numeric data type in sql?

1007

Tell me what is difference between clustered and non clustered index?

947

What stored by the master? : sql server database administration

1115

What is in place upgrade in sql server?

1053

why would you use sql agent? : Sql server database administration

1223

what is create database syntax? : Sql server database administration

1114

How to backup encryption key ?

185

What is awe?

1017

How to name query output columns in ms sql server?

973

Can you edit the .rdl code associated with a linked report?

166