Insert in to emp2 values as select * from emp1;

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?

Question Posted / rafi

8 Answers
12429 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

Please Help Members By Posting Answers For Below Questions

Can a table be moved to different filegroup?

960

What are advantages of ssrs or why we should use ssrs?

137

What is an execution plan?

1119

Explain in details security in SQL azure?

121

What is normalization? Explain different forms of normalization?

1125

How real and float literal values are rounded?

1133

Which joins are sql server default?

979

How to rename an existing table with the "sp_rename" stored procedure in ms sql server?

1011

How do I find the port number for sql server?

955

What do you mean by an execution plan? Why is it used?

993

How to create new tables with "select ... Into" statements in ms sql server?

973

what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration

1007

What is it’s similarity with sql server?

160

What is difference between createstatement and preparedstatement?

1068

can SSRS reports Cache results?

147