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
- 4010 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 to find index size for each index on table?
Does a server store data?
Do you know what are pages and extents? : SQL Server Architecture
What is a trigger what are the advantages of trigger?
What is a data collection table?
Which is the main third-party tool used in sql server?
How do I save a stored procedure in sql server?
How you can change a cross join into an inner join?
Data is not being delivered to subscribers, what can be the possible reasons? : sql server replication
What is the difference between migration and upgradation in sql server?
What is transaction server explicit transaction?
List out the differences between global and local temp tables in sql server?
What is the log shipping?
What does <> symbol mean?
How can you stop stored procedures from recompiling?
