what command is used to create a table by copying the
structure of another table?
Answer Posted / narsing
SELECT * INTO tabname1 FROM tabname2 WHERE 1<>2 (TO copy
only the structure)
Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
Explain different types of lock modes in sql server 2000?
Is truncate a dml command?
Where the sql logs gets stored? : sql server database administration
How do I setup a local sql server database?
Can a trigger be created on a view?
When would you use it?
How to download microsoft sql server 2005 express edition?
Can you explain what are various ways to enhance the ssrs report?
Write a code to select distinct records without using the DISTINCT keyword.
What do we need queues in sql service broker?
Explain where clause?
What are the properties of the transaction?
Explain about Normalization?
What is the use of set nocount on/off statement?
How we create SQL Server 2005 Reporting Services ? Give me Sample