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
- 12182 Views
- I also Faced
- E-Mail Answers
Answer Posted / rajesh.a
Update e2
set e2.empname=e1.empname
from
emp2 e2 inner join emp1 e1 on e1.empid=e2.empid
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?
What are the purposes of floor and sign functions?
How will you find out if there are expensive SQL statements running or not?
How to use the inserted and deleted pseudo tables?
What is DCL?
What is a transaction and why is it important?
Explain an incremental backup?
Can you always create a cache of a report?
What is a data source file?
How to select some specific rows from a table in ms sql server?
List some case manipulation functions in sql?
How do I save a stored procedure in sql server?
What is a fan-out query in SQL Azure?
What are the advantages to use stored procedures?
Why do we use non clustered index?
