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
- 6839 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 a simple table to test triggers in ms sql server?
What happens if null values are involved in boolean operations?
What are the two modes of authentication in sql server?
Explain raiserror in sql server?
Comment,Datatypes are unlimited
What do you mean by an execution plan?
Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many
What is data source document?
What number sorts of privileges are accessible in sql?
Why Master database is required?
Where can you find the error log information? : sql server database administration
Which database stores information about replication?
Do you know concepts and capabilities of sql server?
How do triggers work?
How to apply filtering criteria at group level with the having clause in ms sql server?
