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
- 4002 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
How you can get the list of largest tables in a database?
When I delete any data from a table, does the sql server reduce the size of that table?
Explain datetimeoffset data type in sal server 2008?
What are diverse clauses that form a part of sql?
What is the most common trace flags used with sql server?
Can primary key be a foreign key?
Do you know what are the steps to process a single select statement?
What is ms sql server index?
How to access the deleted record of an event?
What is self contained sub query?
Does any body please help me what question's have asked for SSRS in the interview?
what changed between the previous version of sql server and the current version? : Sql server database administration
What is the Control Flow in SSIS
How to make a column nullable?
What is Extended user-defined?
