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
- 12778 Views
- I also Faced
- E-Mail Answers
Answer Posted / vidya
update emp2 set empname =e.empname from emp1 e where
e.empid =emp2.empid
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.
What is parameterized reports in ssrs ?
How to create a new schema in a database?
What is the query and subquery?
How do you open a cluster administrator?
What is the bookmark lookup and rid lookup?
What is the partitioning method?
Explain about service Broker functions?
What is normalization according to you and explain its different levels?
What is a trigger and types of a trigger?
How to rename an existing column with sql server management studio?
What is a mutating table error and how can you get around it?
How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.
What is sql collation?
what type of index will get created after executing the above statement? : Sql server database administration
