Interested to Buy Any Domain ? << Click Here >> for more details...
How create table structure only from tableA to TableB if
TableA have some data?
- 4 Answers
- 7170 Views
- I also Faced
- E-Mail Answers
Answer Posted / sunny
to copy only the structure
select * into table2 from table1 where 1=2
to copy the table along with the records
select * into table2 from table1 where 1=1
| Is This Answer Correct ? | 12 Yes | 0 No |
Post New Answer View All Answers
What are sql server procedures?
What do you mean by tablesample?
can you instantiate a com object by using t-sql? : Sql server database administration
What are the common performance issues in sql server?
Does index slows down insert statements?
Is mysql the same as sql server?
What is the importance of a recovery model?
How to add an address record into adventureworkslt?
How to create new databases with "create database" statements?
What is an expensive query?
What is nolock hint in sql server 2008
What is 4nf in normalization form?
What is a primary key?
What are the mathematical functions supported by sql server 2005?
How to create a view and a stored procedure in ms sql server using "create view/procedure" statements?
