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
- 12528 Views
- I also Faced
- E-Mail Answers
Answer Posted / saravanan
update w set w.ename=q.ename from empn1 w,
(select e.ename,e.empid from empn e,empn1 a where
a.empid=e.empid) q where w.empid=q.empid
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Is INSTEAD OF trigger directly applicable to Table ?
Why is the need for data conversion transformations?
What are the default system databases in sql server 2000?
How to update muliple row in single query?
What is default constraint in ms sql server?
query processing
How to declare a cursor with "declare ... Cursor" in ms sql server?
Differentiate between a having clause and a where clause.
What is difference between after and before?
Explain triggers?
Write an sql query for deleting duplicate rows?
Can you leave a union at any time?
What is surrogate key? : sql server analysis services, ssas
How to check if stored procedure is running in sql server?
Define primary key?
