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
Explain different forms of normalization?
What are types of subqueries?
How to execute function in stored procedure sql server?
Explain the difference between cross join and full outer join?
Can we create clustered index on composite key?
How to name query output columns in ms sql server?
What is the use of set nocount on/off statement?
Explain indexed views and partitioned view with their syntax.
Do you know what is user defined datatypes and when you should go for them?
Explain the disadvantages/limitation of the cursor?
What is the use of group by clause?
How do you check sql server is up and running?
Explain syntax for viewing, dropping and disabling triggers?
How to call stored procedure using http soap?
How to scale out a federation by Sql statement?