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

Answer Posted / kumar.t

Select * into newnew1 from newnew WHere 1=2

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain different forms of normalization?

687


What are types of subqueries?

749


How to execute function in stored procedure sql server?

753


Explain the difference between cross join and full outer join?

675


Can we create clustered index on composite key?

686






How to name query output columns in ms sql server?

713


What is the use of set nocount on/off statement?

819


Explain indexed views and partitioned view with their syntax.

897


Do you know what is user defined datatypes and when you should go for them?

708


Explain the disadvantages/limitation of the cursor?

710


What is the use of group by clause?

708


How do you check sql server is up and running?

690


Explain syntax for viewing, dropping and disabling triggers?

692


How to call stored procedure using http soap?

705


How to scale out a federation by Sql statement?

110