How to a Query to copy data from on table to another table.

Answer Posted / abhik kumar basu

SELICT * INTO A1 FROM A2

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are Row versions of DataRow?

604


What are the purposes and advantages stored procedure?

495


What is difference between equi join and inner join?

478


How to recompile stored procedure at run time?

565


List the data types available in mssql?

521






What is blocking?

565


what is the difference between them (ethernet networks and token ring networks)? : Sql server database administration

516


Explain foreign key in sql server?

573


What is the difference between ‘having’ clause and a ‘where’ clause?

544


Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .

1485


Explain system rowset functions?

554


How to execute stored procedure and set temp table in sql server?

550


What is the report model project?

103


What are different types of views?

547


How can you list all the columns in a database?

531