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
- 14879 Views
- I also Faced
- E-Mail Answers
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
What do you understand by integration services in sql server?
What are number line correlation administrators will use while working with a subquery?
How many types of the database links?
While migrating Microsoft SQL Server 2008 database to SQL Azure, what can be done to ensure the database connectivity does not degrade?
Which data type columns are the best candidates for full-text indexing?
Do you know what is similarity and difference between truncate and delete in sql?
Can two tables share the same primary key?
What is an execution plan? How would you view the execution plan?
What is Dependency Injection and provide example?
In what sequence sql statement is processed?
Explain the use of keyword with encryption. Create a store procedure with encryption?
What are the disadvantages of using the stored procedures?
How will you optimize a stored procedure optimization?
Recommend an approach to ensuring that all changes in the remote databases synchronize with the SQL Azure database?
Describe how to use linked server?
