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
12785 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

Is sql server a database?

1040

What are the disadvantages of indexes?

1158

What is the exact numeric data type in sql?

1056

Explain the concept of recursive stored procedure.

1024

what stored procedure would you use to view lock information? : Sql server administration

1023

Can we deploy SSRS reports on our personal website?

176

Do you know what is openxml in sql server?

1114

What are the 10 characteristics of data quality?

1005

how to create “alternate row colour”?

152

How to replace null values in expressions using isnull()?

1152

Can another user execute your local temporary stored procedures?

1024

How to create a simple table to test triggers in ms sql server?

1037

What is the difference between delete and truncate statements?

1128

whats new about truncate in sql server 2008?

2555

What are the database objects? : SQL Server Architecture

1098