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
- 12523 Views
- I also Faced
- E-Mail Answers
Answer Posted / pradip jain
update e2
set e2.name= e1.name
from emp2 e2
join emp1 e1 on e1.id=e2.id
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
what exactly sql injuction.how to overcome.....
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?
How do I run a trace in sql server?
what are the different stages of Report Processing?
List types of tables in SQL Azure?
What is model database in sql server?
Why do we use non clustered index?
How do I create a stored procedure in sql server?
what is blocking? : Sql server database administration
How can I know what locks are running on which resource?
How to change parameter value inside the report?
Explain the microsoft sql server delete command? : SQL Server Architecture
How to execute multiple stored procedures at one time in sql server?
Is it possible for a stored procedure to call itself or recursive stored procedure?
How to count duplicated values in a column in ms sql server?
