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
- 12784 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
What are various limitations of the views?
What is the purpose of object explorer and its features? : sql server management studio
What are the new security features added in sql server 2012? : sql server security
What is a unique index?
What xml support does the sql server extend?
How do you clear a log file?
What functions can a view be used to performed?
How does index makes search faster?
How to create a large table with random data for index testing in ms sql server?
What does <> symbol mean?
What the different components of Replication and what is their use?
What is difference between views and stored procedures?
Why do we backup Active Directory ?
What is a deadlock and what is a live lock?
Where sql server user names and passwords are stored in sql server? : sql server database administration
