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
- 12181 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
How do you send email on SQL Server?
what happens on checkpoint? : Sql server database administration
What are triggers? How do you invoke a trigger on demand?
What are the types of indexing?
Explain the categories of stored procedure?
Can a unique index be created on a column, which contains null?
How do I find the sql server instance name?
Explain what is lock escalation and what is its purpose?
What is the latest version of microsoft sql server?
Explain the Ways to improve the performance of a sql azure database?
What is a dataset and what are the different types of datasets?
Difference between report and query parameter. Why do we need different type of parameter?
What do we need queues in sql service broker?
List out some of the requirements to set up a sql server failover cluster?
What are the differences between lost updates and uncommitted dependencies?
