--如存在跨庫鏈接服務器,則刪除IF EXISTS(SELECT * FROM master..sysservers WHERE srvname= 'srv_lnk')EXEC sp_dropserver 'srv_lnk', 'droplogins'--建立跨庫鏈接服務器EXEC sp_addlinkedserver 'srv_lnk','','SQLOLEDB','172.16.14.55'--最后一個參數為數

--如存在跨庫鏈接服務器,則刪除 IF EXISTS(SELECT * FROM master..sysservers WHERE srvname= 'srv_lnk') EXEC sp_dropserver 'srv_lnk', 'droplogins' --建立跨庫鏈接服務器 EXEC sp_addlinkedserver 'srv_lnk','','SQLOLEDB','172.16.14.55'--最后一個參數為數據庫服務器地址 EXEC sp_addlinkedsrvlogin 'srv_lnk','false',null,'sa','sa'--最后兩個個參數為數據庫服務器的登錄用戶名和密碼 id FROM ChinaHRD.dbo.users myCursor myCursor (EMall.dbo.mall_Users AS nUsers WHERE nUsers.Name = (SELECT PetName FROM ChinaHRD.dbo.users oUsers WHERE id=@id)) myTran EMall.dbo.mall_Users(Id,Name, Email,PasswordFormat, Password,UCenterId,CreationTime,LastLoginTime,IsApproved,IsLockedOut,LastActivityTime, LastPasswordChangedTime,LastLockoutTime,FailedPasswordAttemptCount,FailedPasswordAttemptWindowStart,FailedPasswordAnswerAttemptCount, FailedPasswordAnswerAttemptWindowStart,Revenue,RmbBalance) ,,, ,,0.0,0.0 FROM ChinaHRD.dbo.users --向擴展表導入數據 INSERT TableName(ArticleID, XueKe, KanMing,JuanQi, CaiJiWangZhi, CaiJiShiJian,FuJian) SELECT @MaxID,學科,發者,發時,采址,采時, '/attachment/'+附件 FROM OldTableName WHERE id=@id myTranmyTranmyCursor myCursor DEALLOCATE myCursor /* exec sp_dropserver 'srv_lnk', 'droplogins'--刪除跨庫鏈接服務器 ，

聲明：本網頁內容旨在傳播知識，若有侵權等問題請及時與本網聯系，我們將在第一時間刪除處理。TEL:177 7030 7066 E-MAIL:11247931@qq.com