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 / 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
can we have a nested transaction? : Sql server database administration
Is sql server difficult to learn?
How to create a user name in a database?
What is the difference between delete and truncate statements?
Tell me time data type, datetime2, datetimeoffset data type in sql server 2008?
What is the recommended total size of your memory optimized tables?
Why truncate is ddl command?
What are the restraints imposed on the table design by a merge replication?
What are the types of containers in ssis?
How to copy the tables, schema and views from one sql server to another?
How fixed length strings are truncated and padded?
Explain having clause?
Which sql server table is used to hold the stored procedure script?
Why use “pivot” in sql server?
Does partitioning improve performance?