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 restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration

910

How many levels of sp nesting are possible?

1028

what is sql server? : Sql server database administration

991

Tell me what is difference between clustered and non clustered index?

944

how can u get last observation in an unknown dataset ?

2436

What is the definition for sql server 2000?

1090

Explain optimistic and pessimistic concurrency?

993

What is report rendering ?

157

What is clustered primary key?

1028

What xml support does the sql server extend?

1014

What are the lambda triggers?

905

Describe how to use linked server?

1020

How to use column default values in insert statements in ms sql server?

1035

What is abstracting periodical?

946

sql database suspect We have a sql database that is showing as suspect. How can we recover?

1933