SELICT * INTO A1 FROM A2

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

Question Posted / abhik kumar basu

Answer Posted / abhik kumar basu

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

When to use null data driven subscription?

213

What are ddl (data definition language) statements for tables in ms sql server?

1149

Tell me what do you mean by an execution plan? Why is it used? How would you view it?

945

How sql server executes a statement with nested subqueries?

1088

What the difference between UNION and UNIONALL?

1086

can a table be moved to different filegroup? : Sql server administration

1018

in the physical file layout, where should the transaction log be stored in relation to the data file? : Sql server administration

1117

How to enter binary string literals in ms sql server?

1209

What is rtm version in sql server?

1101

What is 5nf in normalization form?

1044

When would you use the stored procedures or functions?

1051

What is data source object?

1064

Which are the third-party tools used in sql server and why would you use them?

959

What is clustered vs nonclustered index?

998

What is a DBMS, query, SQL?

1092