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
- 12264 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
Which are the olap features?
What is wide table?
How to get a list of all tables with "sys.tables" view in ms sql server?
How optimize sql query with multiple joins in sql server?
How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?
How to reaname table name without using sp_Rename in sql server..?
How to include date and time values in sql statements?
How do I setup a local sql server database?
What is the difference between implicit and explicit transaction?
What happens if null values are involved in string operations?
How can you know if the row fetched from cursor is still valid in underlying table?
What is a mutating table error and how can you get around it?
Data table as parameter in sql server?
Differentiate between mongodb vs. Sql server?
What is the use of builtinadministrators group in sql server? : sql server security
