博客

---创建远程链接数据库
        EXEC master.dbo.sp_addlinkedserver @server = N'SQL001', @srvproduct=N'', @provider=N'SQLNCLI', @datasrc=N'192.168.1.243,1433'
        EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'SQL001',@useself=N'False',@locallogin=NULL,@rmtuser=N'sa',@rmtpassword='resset@2023'
        
        ---查看数据库链接状态
        select * from sys.servers
        
        ---删除数据库链接
        exec sp_dropserver'SQL001','droplogins'
        
        ---把远程表导入到本地表
        select * into Company_report20221019.dbo.qfacccmprf0101 from [SQL001].ressettest.dbo.r_ip

        ---把本地表导入到远程表
        insert [SQL001].ressettest.dbo.r_ip select * from Company_report20221019.dbo.qfacccmprf0101

        ---查询远程表
        select * from [SQL001].ressettest.dbo.r_ip