SELECT * INTO tblNew FROM tblOld WHERE 1=2

what command is used to create a table by copying the
structure of another table?

Question Posted / pradip jain

Answer Posted / pradip jain

Is This Answer Correct ?

7 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How to write a query with an inner join in ms sql server?

1020

Does index slows down insert statements?

980

Which operator do you use to return all of the rows from one query except rows are returned in a second query?

975

What is the optimization being performed in oracle and SQL Server?

1028

What does it mean if @@cursor_row returns a negative number?

976

You want to use a perspective in an mdx query. How do you select the perspective?

239

What is single-user mode?

910

What type of locking occurs during the snapshot generation? : sql server replication

1317

What is equi join with example?

1096

Difference between report and query parameter.

1060

How does a profiler work?

906

Does group by or order by come first?

933

What is indexed view?

963

What is update locks?

865

Relational calculus is what type of language?

1013