update emp2 e2 set e2.empname = (select e1.empname from emp1 e1 where e2

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

8 Answers
12522 Views
I also Faced
E-Mail Answers

Answer Posted / vicky

update emp2 e2 set e2.empname = (select e1.empname from
emp1 e1 where e2.empid=e1.empid)

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to loop through the result set with @@fetch_status?

1349

What is instead of trigger sql server?

1002

What is candidate key with example?

975

How do you manipulate data?

910

Explain table valued parameters in sql server? Why tvp used?

1019

What are out-of-range errors with date and time literals?

1030

What is Sqlpaging in SqlServer 2005 ?

1069

What is field with example?

925

How do we know if any query is retrieving a large amount of data or very little data?

975

What is triggers and its types?

1009

What are the types of dml?

981

What is table join?

1118

Explain database normalization?

1229

what method you can use to reduce the overhead of Reporting Services data sources?

255

How to encrypt data between dialogs?

1109