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
- 12431 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 optimize sql query with multiple joins in sql server?
How do you maintain database integrity where deletions from one table will automatically cause deletions in another table?
What is indexed view?
How would you choose between a clustered and a non-clustered index?
What are the different types of cursor?
What do you mean by data manipulation language?
Does a server store data?
What is the full meaning of dml?
What is best institute to Learn DotNET And SQL in chennai?
Do you know what are the differences between lost updates and uncommitted dependencies?
What is CTE in SQL
How does a profiler work?
What do you mean by SQL injection attack?
Is it possible to replicate data from sql server to oracle? : sql server replication
Explain linked server in sql?
