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?
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 are the system database in sql server 2008?
How will you optimize a stored procedure optimization?
What is a dbms wizard?
How to get the definition of a stored procedure back?
How to drop an existing table with "drop table" statements in ms sql server?
Explain partitioned view?
In which tcp/ip port does sql server run? Can it be changed?
How many types of relations are there between dimension and measure group? : sql server analysis services, ssas
Why use “nolock” in sql server?
What authentication modes does sql server support?
What are the pros and cons of putting a scalar function in a queries select list or in the where clause?
What is the difference between for auto and for nested?
Describe how to use the linked server?
Why are sql functions used?
What is difference between clustered and non clustered index?