p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   SQL Language (http://p2p.wrox.com/forumdisplay.php?f=100)
-   -   copy complete data in one table to another (http://p2p.wrox.com/showthread.php?t=39194)

ramanadyv March 1st, 2006 05:20 AM

copy complete data in one table to another
 
Hi,
  Can any one send me the query for following requirement.
  How to copy the complete data in one table to another new table.

Thanks & Regards,
venkat.


mat41 March 1st, 2006 07:51 PM

Your solution:

http://www.experts-exchange.com/Data..._20968600.html

I would use DTS. Do you need a web page to do this or do you have EM available?

Wind is your friend
Matt

jbenson001 March 4th, 2006 11:53 PM

Select *
Into <new table>
From <old table>



All times are GMT -4. The time now is 08:47 PM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.