what command is used to create a table by copying the
structure of another table?
- 7 Answers
- 13674 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
What are “lock” hints?
What are the Advantages of using CTE in sql server?
What is the difference between varchar and nvarchar datatypes?
What are various ways to enhance the ssrs report?
Define Business Edition in SQL Azure?
New concepts of sql server 2005 use in your project.
What is a constant or literal in ms sql server?
there is a trigger defined for insert operations on a table, in an oltp system. The trigger is written to instantiate a com object and pass the newly inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? : Sql server database administration
How to convert a unicode strings to non-unicode strings?
Explain various On-Delete options in a DB table. Which is the default option?
How to add additional conditions in SQL?
What is collation sensitivity? Explain different types.
What are built in functions?
What is RAID? What are the different types of RAID configurations?
Define left outer join?
