update emp2 set empname =e.empname from emp1 e where e.empid =emp2.empid

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

8 Answers
12529 Views
I also Faced
E-Mail Answers

Answer Posted / vidya

update emp2 set empname =e.empname from emp1 e where
e.empid =emp2.empid

Is This Answer Correct ?

1 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What does nvl stand for?

946

what protocol both networks use? : Sql server database administration

974

Explain about nested stored procedure?

1037

What are the approximate numeric data types?

941

What is 2nf in normalization?

1002

How to add additional conditions in SQL?

1025

What are blobs, tables, and Queues? Is SQL is the standard way to query blobs, tables, and queues?

137

explain what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration

943

What does dml stand for?

952

What is a sql join?

1025

what is the difference between delete table and truncate table commands? : Sql server database administration

1040

What is the most common type of join?

995

How does the report manager work in SSRS?

150

Is port 1433 secure?

999

What is normalization? Explain different forms of normalization?

1166