How create table structure only from tableA to TableB if
TableA have some data?
Answer Posted / anand.kv
SELECT TOP 0 * INTO tableB FROM tableA
| Is This Answer Correct ? | 16 Yes | 0 No |
Post New Answer View All Answers
What is BCP? When does it used in sql server 2012?
What is log shipping? Can we do logshipping with SQL Server 7.0 ?
Can we add a cpu to sql server?
What guidelines should be followed to help minimize deadlocks?
What is “begin trans”, “commit tran”, “rollback tran” and “savetran”?
Which event (check constraints, foreign key, rule, trigger, primary key check) will be performed last for an integrity check?
List all the types of user-defined functions?
What are the different types of backups avaialabe in sql server 2005?
What is openrowset sql server?
Does partitioning ssd reduce performance?
Tell me what do you mean by an execution plan? Why is it used? How would you view it?
What is indexed view?
Why I can not enter 0.001 second in date and time literals in ms sql server?
How to execute a sql statement using mssql_query()?
How to insert data with null values?