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

How do I edit a stored procedure in sql server?

923

Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security

1049

how can u get last observation in an unknown dataset ?

2436

What are the different editions available in sql server 2000?

1050

What is resource governor?

972

How many databases can we create in a single server?

207

Is it possible to run multiple publications and different type of publications from the same distribution database? : sql server replication

978

Define inner join in sql server joins?

1057

Do you know what is sql injection?

998

What are the operating modes in which database mirroring runs?

1087

Explain foreign key in sql server?

1027

What are the new features of sql server 2012 reporting service?

133

How to list all schemas in a database?

1056

How to backup encryption key ?

182

Detail about the hardware which is supported by SQL server?

1063