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
12173 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 is the difference between varchar and varchar(max) datatypes?

999

List out the differences between global and local temp tables in sql server?

997

Define Joins?

972

Explain a differential backup?

946

plss anybody specify tha constrian management system in dbms

2078

can an order by clause be used in a creation of a view?

1098

what are defaults? : Sql server database administration

1002

How many database files are there in sql server 2000?what are they?

976

What is the server name in sql server?

956

In which files does sql server actually store data?

849

Can a synonym name of a table be used instead of a table name in a select statement?

972

What is table join?

1065

What is the name of the system variable that returns the number of rows affected by a SQL statement?

966

What is outer join in sql server joins?

1044

What is rs.exe utility?

150