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
How to write a query with an inner join in ms sql server?
Does index slows down insert statements?
Which operator do you use to return all of the rows from one query except rows are returned in a second query?
What is the optimization being performed in oracle and SQL Server?
What does it mean if @@cursor_row returns a negative number?
You want to use a perspective in an mdx query. How do you select the perspective?
What is single-user mode?
What type of locking occurs during the snapshot generation? : sql server replication
What is equi join with example?
Difference between report and query parameter.
How does a profiler work?
Does group by or order by come first?
What is indexed view?
What is update locks?
Relational calculus is what type of language?