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
- 12783 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 many clustered indexes there can be on table ?
Does the unique constraint create an index?
What is merge join?
How to filter records of table in SQL SERVER?
List the different normalization forms?
What are types of subqueries?
where can you add custom error messages to sql server? : Sql server administration
Explain what is analysis service repository?
What are the limitations/drawbacks or ssrs 2008 r2?
Why truncate is ddl?
Explain about protocol layer present in SQL server?
Does partitioning improve performance?
Where sql server user names and passwords are stored in sql server? : sql server database administration
What is a not null constraint?
What is 2nf example?
