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?
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
Define Joins?
What are date and time data types in ms sql server?
What is a join in sql? What are the types of joins?
When I run the sql server 2000 setup, it just hangs. What do I do?
How we create SQL Server 2005 Reporting Services ? Give me Sample
Can we call future method from trigger?
Explain the etl (extraction, transformation, and loading)?
What is truncate table?
What is the usage of sign function?
What is wide table?
What is sql azure database?
Can I run multiple instances of sql server 2000 at the same time on one computer?
Can you create a logon trigger in sql server 2005 express edition?
What is de-normalization in sql database administration? Give examples?
What is the difference between update lock and exclusive lock?