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

How do you start single user mode in clustered installations?

525


What is database isolation in sql server? : sql server database administration

570


Define a cross join?

598


What is the sql case statement used for?

563


what is new philosophy for database devises for sql server 7.0? : Sql server database administration

519






Tell me what is the stuff and how does it differ from the replace function?

542


Explain system views?

584


How to create and drop temp table in sql server?

591


how you can move data or databases between servers and databases in sql server? : Sql server administration

489


Is there any difference between primary key and unique with the not null condition?

530


How to use union to merge outputs from two queries together in ms sql server?

562


What does REVERT do in SQL Server 2005?

569


In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram

1518


What is the use of custom fields in report?

561


Which tools are available to manage SQL Azure databases and servers?

93