Interested to Buy Any Domain ? << Click Here >> for more details...
what command is used to create a table by copying the
structure of another table?
- 7 Answers
- 14827 Views
- I also Faced
- E-Mail Answers
Answer Posted / hokar
SELECT * INTO tabname1 FROM tabname2 WHERE 1=2 (TO copy
only the structure)
| Is This Answer Correct ? | 18 Yes | 4 No |
Post New Answer View All Answers
Your company has 50 branches all over the country all the branches, including the head office have sql server as the database every night all 50 branches upload certain information to the head office which replication topology is best suited for the above scenario?
How to use linked server?
what changed between the previous version of sql server and the current version? : Sql server database administration
What stored by the master?
What are the parts of a function?
How do you create a clustered index?
What is a print index?
What happens if the update subquery returns no rows in ms sql server?
Can you change the data type of a column in a table after the table has been created? If so, which command would you use?
Differentiate between ms sql server reporting services vs crystal reports?
What xml support does the sql server extend?
Explain how dts is used to extract, transform and consolidate data?
How you can get a list of all the table constraints in a database?
What are the dis_advantages of stored procedures, triggers, indexes?
Does sql server 2000 clustering support load balancing?
