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
- 12521 Views
- I also Faced
- E-Mail Answers
Answer Posted / dhana
update e2 set e2.empname = e1.empname
from emp2 e2,emp1 e1
where e1.empid = e2.empid
| Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
What is difference between commit and rollback when used in transactions?
What are sql dirty pages?
How to create new table with "create table" statements?
What are the different Authentication modes in SQL Server and how can you change authentication mode?
How to replace given values with null using nullif()?
Explain primary key, foreign key and unique key?
What is wrong with sql server client libarary dll, ntwdblib.dll?
What is 2nf normalization form?
How do you trace the traffic hitting a sql server?
What is postgresql server?
What is SubQuery in SQL Server 2008
Does partitioning help performance?
What is query optimization process?
What are window functions in sql server?
How to view existing indexes on an given table using sp_help?
