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

Your table has a large character field there are queries that use this field in their search clause what should you do?

854

What is resource governor?

926

What is server-level principal?

120

What is indexed view? How to create it?

932

What is the full form of ddl?

866

Why is sql server log file full?

979

what's sql server? : Sql server database administration

931

What is a trigger and its types?

929

How to create a simple stored procedure in ms sql server?

979

How many categories of functions based their return modes?

1063

What is a domain constraint give an example?

1005

What is a covering index?

920

What is difference between Datepart() and Datename() in SqlServer?

1158

Explain the third normal form(3nf)?

896

Can we write a distributed query and get some data which is located on other server and oracle database?

1178