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
- 4073 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 are the advantages of sql stored procedure?
What is attribute relationships, why we need it? : sql server analysis services, ssas
How do you identify a foreign key?
How to throw custom exception in Stored Procedure?
What is replication with database mirroring? : sql server database administration
What is a Join and explain its types?
How to list all triggers in the database with sys.triggers in ms sql server?
Explain how to maintain a fill factor in existing indexes?
What is difference between inner join and join?
how would you troubleshoot blocking? : Sql server database administration
How to recreate an existing index in ms sql server?
How to connect to a sql server using odbc_connect()?
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?
What according to you is the difference between mysql and sql server performance?
What are sub reports?
