Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 8 Answers
- 12172 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
How to transfer data from a cursor to variables with a "fetch" statement?
how to do partition in sqlserver
Explain “@@rowcount” and “@@error” in sql server?
what is raid and what are different types of raid configurations? : Sql server database administration
Is null in sql server?
Explain sql delete command?
What is the architecture of ms sql reporting service?
What is the synonym of join?
What is scrollable cursor?
How do I setup a sql server database?
Can an entity have two primary keys?
Suppose you want to implement the many-to-many relationships while designing tables. How would you do it?
Explain what is “asynchronous” communication in sql server service broker?
What is constraints and its types?
What is ddl command?
