Interested to Buy Any Domain ? << Click Here >> for more details...
hw you create table in sql using existing table and variable
should be in specific order given ex : in old table empid
empname empsal empage empbirthdate empaddrs like is there in
new table we need it as EX: exmpname empage empaddrs empid
empbirthdate like we want hw we create this as a table not
view or nt reporting
- 2 Answers
- 4097 Views
- I also Faced
- E-Mail Answers
Answer Posted / abhinay
select * into table_name from destination_table_name where 1=0
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
What is indexing and its types?
What is the exact numeric data type in sql?
How much memory that we are using in Logshipping Concept?
What are Row versions of DataRow?
What are the advantages of having an index on the sql server?
What is the purpose of the tempdb database?
Describe and explain about SQL native client?
What is 4nf in normalization form?
Can you please differentiate between a primary key and a unique key?
What gets stored inside msdb database?
What can be used instead of trigger?
What is function of ROLLUP ?
How to create an index on an existing table in ms sql server?
What is extended stored procedures?
What is a fill factor?
