Chad, Tedious or not it is considered by many as a best practice to name your columns.
Select * is the bane of my existence many times. Steve -----Original Message----- From: Chad Gray [mailto:[email protected]] Sent: Tuesday, December 15, 2009 11:55 AM To: cf-talk Subject: copy from table to table Is there any easy way to take a row of data from one table and copy it to another? The tables have the exact same columns, they just have different table names. The tables have many columns so typing out each column in an insert query will be tedious. Any ideas would be appreciated! Chad ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329160 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
