创建方法:
exec sp_addlinkedserver ' LINK198','','SQLOLEDB','你的服务器地址'
exec sp_addlinkedsrvlogin ' LINK198','false',NULL,'数据库账号','数据库密码'
使用方法:
INSERT INTO LINK198.[ShortMessage].dbo.S_Message(SMS_BusinessId,SMS_CreateDate,SMS_State,SMS_Telephone,SMS_Content,SMS_SendTypeId)
VALUES('管理中心',getdate(),0,@ReceivePersonPhone,@sms_content,1)