How create table structure only from tableA to TableB if
TableA have some data?
- 4 Answers
- 6301 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 the disadvantages of using querystrings to send data from one page to another?
Why SQL Agent is used?
What is bit data type?
Tell me what is normalization? Explain different forms of normalization?
Explain how you can configure a running aggregate in SSRS?
What is the standby server?
How to create new tables with "create table" statements in ms sql server?
how would you store your query in an SSRS report or a Database server?
What does the update command do?
What is left outer join in sql server joins?
What is query cost in sql server?
Explain triggers in sql?
What is a result set object returned by odbc_exec()?
Write a code to select distinct records without using the DISTINCT keyword.
What are trace flags and mention a few common trace flags used with sql server?
