How can I create a table from another table without copying any values from the old table?
Answer Posted / arun
Select top 0
into newtable
from oldtable
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
How will you add a dimension to cube? : sql server analysis services, ssas
Tell me what is sql profiler?
why does a sql statement work correctly outside of a user-defined function, but incorrectly inside it? : Sql server administration
What is trace flag in sql server?
What are partitioned views and distributed partitioned views?
Can we hide the definition of a stored procedure from a use?
How to create an inline table-valued function?
What is instead of dml trigger?
What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?
What is an indexed view?
What is enhanced database mirroring in sql server 2008?
How is table type constraint applied to a table?
What is a view and what are its advantages?
What do you mean by recursive stored procedure?
Explain what is the main purpose of having conversation group?