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 information schema views?

540


When is the use of update_statistics command?

549


What do you understand by physical_only option in dbcc checkdb?

574


How real and float literal values are rounded?

576


What is the purpose of floor function?

529






What are the advantages of paper records?

547


In which sql server version report builder introduced?

105


Do you know what is a trace frag? Where do we use it?

545


What are the indexes in sql server?

496


What are the difference between data mart and data warehouse? : sql server analysis services, ssas

495


How to defragment indexes with alter index ... Reorganize?

576


How to create a view and a stored procedure in ms sql server using "create view/procedure" statements?

501


What is data block and how to define data block size?

593


How to create a dynamic cursor with the dynamic option?

544


What is difference between delete & truncate commands?

538