建立遠端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