SELECT TOP 0 * INTO tableB FROM tableA

How create table structure only from tableA to TableB if
TableA have some data?

Question Posted / anand.kv

Answer Posted / anand.kv

Is This Answer Correct ?

16 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is BCP? When does it used in sql server 2012?

1061

What is log shipping? Can we do logshipping with SQL Server 7.0 ?

993

Can we add a cpu to sql server?

1011

What guidelines should be followed to help minimize deadlocks?

943

What is “begin trans”, “commit tran”, “rollback tran” and “savetran”?

1025

Which event (check constraints, foreign key, rule, trigger, primary key check) will be performed last for an integrity check?

1007

List all the types of user-defined functions?

1099

What are the different types of backups avaialabe in sql server 2005?

1020

What is openrowset sql server?

1127

Does partitioning ssd reduce performance?

894

Tell me what do you mean by an execution plan? Why is it used? How would you view it?

883

What is indexed view?

980

Why I can not enter 0.001 second in date and time literals in ms sql server?

1065

How to execute a sql statement using mssql_query()?

1051

How to insert data with null values?

1025