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 / 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
Indexes are updated automatically is the full-text index also updated automatically?
How do I find the port number for sql server?
Where in ms sql server is ’100’ equal to ‘0’?
What stored by the msdb? : sql server database administration
What according to you is the difference between mysql and sql server performance?
Define master database?
What are the different subsets of sql?
Do you know query execution plan?
Explain throw statement in sql server 2008?
What is BCNF? How is it better than 2NF & 3NF?
what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration
How column data types are determined in a view?
What is precedence constraint?
What is the default schema of your login session in ms sql server?
How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?