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
- 7002 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
How to create prepared statements using odbc_prepare()?
What are user defined functions in ms sql server?
How do I view a stored procedure in sql server query?
Explain candidate key, alternate key, and composite key?
What is collation sensitivity?
How to enter binary string literals in ms sql server?
What happens if null values are involved in bitwise operations?
What is cte (common table expression)?
what is an extended stored procedure? Can you instantiate a com object by using t-sql? : Sql server database administration
What is inline table-value user-defined function?
What is a view and what are its advantages?
What is the purpose of the model database?
Can group functions be used in the order by clause in ms sql server?
Tell me extended events in sql server 2008?
Explain about protocol layer present in SQL server?
