EasyCFM.COM ColdFusion Forums / MS SQL Server Related Issues / Copying a table

   Reply to Discussion | New Discussion << previous || next >> 
Posted By Discussion Topic: Copying a table

book mark this topic Printer-friendly Version  send this discussion to a friend  new posts last

DanBWeb
09-03-2007 @ 4:42 PM
Reply
Edit
Profile
Send P.M.
My Gravatar!
Powered by Gravatar
New Member
Posts: 14
Joined: Sep 2004

Hello -

I am using Cold Fusion and I want to be able to run a scheduled task that will copy a SQL table and rename it with another name - in the same database

Any help appreciated

Dan B

This message was edited by DanBWeb on 9-3-07 @ 5:08 PM

Scarecrow
08-06-2008 @ 1:37 AM
Reply
Edit
Profile
Send P.M.
My Gravatar!
Powered by Gravatar
Junior Member
Posts: 109
Joined: Oct 2004

It's easy, just a query will do it...

Insert Into (NEWTABLENAME)
Select * From OLDTABLENAME

Ken

www.scarecrowapplications.com

This message was edited by Scarecrow on 8-6-08 @ 1:38 AM


Website Designed and Developed by Pablo Varando.