The from is MS Sql Server 2k, and the from is MSDE 2K. Rodger -----Original Message----- From: Tyler Fitch [mailto:[EMAIL PROTECTED] Sent: Thursday, October 28, 2004 3:39 PM To: CF-Talk Subject: Re: OT: Sql insert from one db to another
Rodger, What database platform are you running on? t On Thu, 28 Oct 2004 14:25:14 -0700, Rodger <[EMAIL PROTECTED]> wrote: > I can use an INSERT to copy the data from one table to another like: > > INSERT empinfoEmployeesTemp (EmployeeNum, FirstName, LastName) > (SELECT EmployeeNum, FirstName, LastName > FROM empinfoEmployees) > > But I need to copy the data from different databases (production to dev). > How can I specify which db each table lives in? > > Rodger > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| The annual ColdFusion User Conference is being held Sat 6/26 - Sun 6/27/04 8am-5pm in the Washington DC Area. http://www.houseoffusion.com/banners/view.cfm?bannerid=44 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182891 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54