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
- 12427 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
What happens when the SQL Azure database reaches Max Size?
Give the query of getting last two records from the table in SQL SERVER?
why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it? : Sql server administration
How can I track the changes or identify the latest insert-update-delete from a table?
What is nested transaction?
What is the default Port No on which SQL Server listens?
Explain foreign key in sql server?
What is the current pricing model of SQL Azure?
What is BCP? When does it used in sql server 2012?
Explain having clause and where clause?
What are the two authentication modes in sql server?
How do I find the sql server instance name?
Does group by or order by come first?
What is 1nf normalization form?
How can you check the level of fragmentation on a table?
