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
- 12516 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
What is sqlservr.exe - process - sql server (sqlex?press)?
in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it
What are the advantages of partitioning?
What extended events?
Explain the properties of a relational table?
How do you use a subquery to find records that exist in one table and do not exist in another?
What is the use of “join” in sql server?
How to replace null values in expressions using isnull()?
How to make a remote connection in a database?
What are the system database in sql server 2005?
How to fetch the next row from a cursor with a "fetch" statement?
What is built-in/administrator?
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?
How do I know if localdb is running?
What is the purpose of grouping data in a report?
