Select * into newnew1 from newnew WHere 1=2

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

Question Posted / kumar.t

Answer Posted / kumar.t

Is This Answer Correct ?

4 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is amo? : sql server analysis services, ssas

1092

Is candidate a key?

955

What are differences in between sql server 2012 and sql server 2016?

1053

What do you mean by collation recursive stored procedure?

1056

When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?

1104

What is a recursive stored procedure in sql server?

1178

What is normalization? Describe its different types.

1106

Can we insert data into a view?

1143

What is etl - extraction, transformation, and loading?

919

Explain about integration services of Microsoft SQL server?

1038

If any stored procedure is encrypted, then can we see its definition in activity monitor?

994

How to find the version of sql server? : sql server database administration

1114

What is the name of reporting services config file and what’s it’s used for?

146

What is the concept of optimization?

1060

How to declare a cursor with "declare ... Cursor" in ms sql server?

1049