 -- 建立链接服务器，并提供登录信息 -- 请修改 @datasrc 为备份服务名 exec sp_addlinkedserver @server=backupserver, @srvproduct=, @provider=sqloledb, @datasrc=servercomputername go -- 请修改 @rmtuser、@rmtpassword 参数为备份服务器sql server登录帐号 exec sp_addlinkedsrvlogin @rmtsrvname=backupserver,@useself=false,@locallogin=null,@rmtuser=sa,@rmtpassword=pass go -- 把数据保存到备份服务器 -- dbname应修改备份服务器数据库名 insert into backupserver.dbname.dbo.mastertable select * from mastertable where keyfield in (value1,value2) go insert into backupserver.dbname.dbo.mastertabledetail select * from mastertabledetail where (select keyfield from mastertable where mastertabledetail.mastertableid=mastertable._id) in (value1,value2) go -- 删除本数据库记录 delete from mastertable where keyfield in (value1,value2) go delete from mastertabledetail where (select keyfield from mastertable where mastertabledetail.mastertableid=mastertable._id) in (value1,value2) go |
喜欢本文，那就收藏到： |
.text:''):(d.getSelection?d.getSelection():'');void(keyit=window.open('http://my.poco.cn/fav/storeIt.php?t='+escape(d.title)+'&u='+escape(d.location.href)+'&c='+escape(t)+'&img=http://www.h-strong.com/blog/logo.gif','keyit','scrollbars=no,width=475,height=575,status=no,resizable=yes'));keyit.focus(); "添加到POCO网摘"){kind=logo}
Rss Feed
