Update emp2 set empname = (Select empName from emp1 where emp2.empid =emp1

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 / a

8 Answers
12428 Views
I also Faced
E-Mail Answers

Answer Posted / a

Update emp2 set empname = (Select empName from emp1 where
emp2.empid =emp1.empid)

Is This Answer Correct ?

2 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the difference between a fill factor of 100 and 0?

964

How will you decide the active and passive nodes?

1113

Will sql server 2005 allow you to reduce the size of a column?

967

How to rename an existing column with the "sp_rename" stored procedure in ms sql server?

1084

Can binary strings be converted into numeric or float data types?

1007

What are the advantages dts has over bcp?

978

What is sql server replication? : sql server replication

964

what information is maintained within the msdb database? : Sql server administration

944

How many databases Microsoft SQL server provides?

1069

Is sql server is free?

952

What is data file in computer?

926

How to use “drop” keyword in sql server and give an example?

1113

How do I edit a stored procedure in sql server?

905

Delete duplicate rows without using rowid.

1526

What is “begin trans”, “commit tran”, “rollback tran” and “savetran”?

1002