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
- 12186 Views
- I also Faced
- E-Mail Answers
Answer Posted / dhana
update e2 set e2.empname = e1.empname
from emp2 e2,emp1 e1
where e1.empid = e2.empid
| Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
How do indexes help, types?
you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration
How many types of relations are there between dimension and measure group? : sql server analysis services, ssas
What is 2nf example?
Does partitioning ssd reduce performance?
What is sql server 2000 work load governor?
How do I make a resultset scrollable?
Difference between report and query parameter. Why do we need different type of parameter?
What is a subquery in a select query statement in ms sql server?
What are the different Topologies in which Replication can be configured?
which backup strategy you are following at ur company
What is the federation in sql azure?
What is catalog views?
Which is faster statement or preparedstatement?
What is tcl in sql server?
