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
- 4201 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / raj sekhar
select empname,empage,empaddrs,empid,empbirthdate into
newemptable from oldemptable
| Is This Answer Correct ? | 4 Yes | 1 No |
Answer / abhinay
select * into table_name from destination_table_name where 1=0
| Is This Answer Correct ? | 0 Yes | 3 No |
Why use “nolock” in sql server?
Explain the use of containers in ssis and also their types?
What are the recovery models for a database?
Can you explain about buffer cash and log cache in sql server?
What xml support does the sql server extend?
what's the difference between delete table and truncate table commands? : Sql server database administration
Do you know how to send email from database?
What is difference between drop truncate and delete?
What are the events recorded in a transaction log?
What do you understand by physical_only option in dbcc checkdb?
Explain the dbcc pintable command when would you use it?
Is port 1433 secure?
-
Oracle (3253) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
