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
12517 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

What are logical database components? : SQL Server Architecture

1035

How to use values from other tables in update statements in ms sql server?

1118

Does the order of columns in update statements matter?

913

on line cluster can we make if yes tell me the procedure

2023

What is scan table/view and seek table/view when its occurs? : sql server database administration

1048

Explain steps of normalization?

1004

Explain what are the different index configurations a table can have?

1110

What are the advantages of log shipping?

996

How many columns can exist together per table?

1156

Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?

962

How check triggers in sql server?

991

What Are the Main Features of SQL Azure?

117

What is temporary table in sql server? Why we use temp table?

952

What is difference between Datepart() and Datename() in SqlServer?

1204

How can you tell if a database object is invalid?

1074