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
- 12530 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
Is sql server difficult to learn?
What are the properties of sub-query?
explain declarative management framework (dmf) in sql server 2008?
How to get a list of columns using the "sp_help" stored procedure in ms sql server?
How do you start single user mode in clustered installations?
You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?
Can you name a few encryption mechanisms in sql server?
What is sql server used for?
Can a cursor be updated? If yes, how you can protect which columns are updated?
What is bit data type? What's the information that can be stored inside a bit column?
How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?
Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you
What are locks in sql?
How to defragment table indexes?
How to access the deleted record of an event?
