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
- 12183 Views
- I also Faced
- E-Mail Answers
Answer Posted / a
Update emp2 set empname = (Select empName from emp1 where
emp2.empid =emp1.empid)
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
Explain Normalization and DE normalization
Suggest a method of joining two tables.
How to perform backup for certificates in sql server? : sql server security
How to get the definition of a user defined function back?
What is a derived table?
Your table has a large character field there are queries that use this field in their search clause what should you do?
Explain ms sql server reporting services vs crystal reports?
What is snapshot report?
What do you understand by physical_only option in dbcc checkdb?
Tell me can we use custom code in ssrs?
what types of replication are supported in sql server? : Sql server database administration
What is a schema in ms sql server 2005?
Your company has 50 branches all over the country all the branches, including the head office have sql server as the database every night all 50 branches upload certain information to the head office which replication topology is best suited for the above scenario?
What are the different types of sql server replication? : sql server replication
How to retrieve field values using mssql_result()?
