update e2 set e2.name= e1.name from emp2 e2 join emp1 e1 on e1.id=e2.i

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 / pradip jain

8 Answers
12782 Views
I also Faced
E-Mail Answers

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is right outer join in sql server joins?

1220

Explain foreign key in sql server?

1074

What is ddl command?

1034

What are the differences between char and nchar in ms sql server?

1144

Explain different types of locks in sql server.

1129

Define indexes?

1095

What to perform pattern match with the like operator?

934

What is attribute? : sql server analysis services, ssas

1069

Tell me in brief how sql server enhances scalability of the database system?

1040

Define Unique Key?

1066

What is the difference between a check constraint and a rule?

1351

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

1096

What are the limitations/drawbacks or ssrs 2008 r2?

152

What do mean by xml datatype?

1175

Do you know what is a linked server in sql server?

1070