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
- 9976 Views
- I also Faced
- E-Mail Answers
Answer Posted / rafi
Insert in to emp2 values as select * from emp1;
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
How many columns can exist together per table?
How will you hide an attribute? : sql server analysis services, ssas
What is the difference between Triggers and Stored Procedure?
What is the beast way to write CTE in SQL Server ?
What is difference between delete & truncate commands?
How to provide column names in insert statements in ms sql server?
How to delete an existing row with delete statements in ms sql server?
what is unique and xaml nonclustered index
What happens if null values are involved in comparison operations?
When you should use a low fill factor?
What are the new features are introduced in sql server 2012 reporting services?
What is difference between equi join and inner join?
How many levels of sp nesting are possible?
What are trace flags?
Which are ddl commands?
