SELECT * INTO tabname1 FROM tabname2 WHERE 1<>2 (TO copy only the s

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

Question Posted / narsing

Answer Posted / narsing

SELECT * INTO tabname1 FROM tabname2 WHERE 1<>2 (TO copy
only the structure)

Is This Answer Correct ?

0 Yes

3 No

Please Help Members By Posting Answers For Below Questions

When cursors are useful?

1091

What is the difference between implicit and explicit transaction?

1004

When do you think a developer should use sql server-based cursors?

1041

What is normalization and denormalization in sql server?

1002

What are the general features of sql server management studio? : sql server management studio

1071

How to enter date and time literals in ms sql server?

1007

Explain the microsoft sql server delete command? : SQL Server Architecture

1072

Explain tables in SQL Azure?

120

Explain can SSRS reports Cache results?

158

Do you know what are the reporting services components?

971

Explain different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

1032

What is the simplest way to create a new database in ms sql server?

1002

What is standby servers? Explain types of standby servers.

990

Does union all remove duplicates?

1057

What extended events?

999