what command is used to create a table by copying the
structure of another table?
Answer Posted / pradip jain
SELECT * INTO tblNew FROM tblOld WHERE 1=2
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
What are the tools available in market as an alternative to sql server reporting services?
What are partitioned views and distributed partitioned views?
How do you drop an index?
Find columns used in stored procedure?
What is transactional replication?
You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?
How do I start and stop sql server?
What are a scheduled jobs or what is a scheduled tasks?
Tell me what do you understand by a view? What does the with check option clause for a view do?
Explain database normalization?
How to find Duplicate Records In table?
How can you ensure that the database and sql server based application perform well?
What are the new data types are introduced in sql 2000?
What are the features of Embedded SQL
What is query cost in sql server?