p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   SQL Server 2000 (http://p2p.wrox.com/forumdisplay.php?f=20)
-   -   open connection in another connection (http://p2p.wrox.com/showthread.php?t=42090)

adityamadisetty May 3rd, 2006 11:46 PM

open connection in another connection
 
i want to update a database using another database with same data.Like keeping back up.can anybody help ame the querry.

bcpquery = "insert into upsselector1 (device,va,deviceType) select (device,va,deviceType) from upsselector"



r_ganesh76 May 4th, 2006 04:56 AM

Are you talking about a backing up a Database or backing up a Table?

Regards
Ganesh
http://ganeshprof.blogspot.com


All times are GMT -4. The time now is 08:04 AM.

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