建立遠端view

USE KingMaker --目前使用的db

EXEC sp_addlinkedserver @server = '172.16.1.234', @srvproduct = N'SQL Server'

EXEC sp_addlinkedsrvlogin @rmtsrvname = '172.16.1.234' , @useself = false, @rmtuser = 'sa', @rmtpassword = 'p@ssw0rd@fc0'

CREATE VIEW [dbo].[baccount_DEPT]

AS

SELECT DEP_NO, ID FROM [172.16.1.234].ofco.dbo.baccount_DEPT

GO