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
- 14908 Views
- I also Faced
- E-Mail Answers
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
How many types of keys are there?
When to use null data driven subscription?
What is a join in sql? What are the types of joins?
Tell me what is de-normalization and what are some of the examples of it?
What is dbcc command in sql server?
How to see the event list of an existing trigger using sys.trigger_events?
What is difference between joins and subqueries?
Which event (check constraints, foreign key, rule, trigger, primary key check) will be performed last for an integrity check?
Explain what are the basic functions for master, msdb, model, tempdb databases?
What is the difference in accessing db between sql server vs sql azure?
What is difference between temp table and cte?
How many types of triggers are there?
What is bit data type? What's the information that can be stored inside a bit column?
How to create function with parameter in sql server?
What is the difference between sql server 2000 object owner and sql server 2005 schema? : sql server database administration
