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
What are the differences between stored procedure and the dynamic sql?
How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?
What is mean by clustered index and non clustered index, give syntax of creation? : sql server database administration
Explain the difference between delete,drop and truncate in SQL Server?
Define model database?
Can we use trigger new in before insert?
Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...
what is dbcc? : Sql server database administration
What are the new security features added in sql server 2012? : sql server security
How except clause is differs from not in clause?
Define ACID properties in a Database?
how would you improve etl (extract, transform, load) throughput?
Is natural join and equi join same?
Explain identity in sql server?
How do I manually uninstall an instance of sql server 2016?