[MSSQL]跨数据库查询

DECLARE @server SYSNAME=‘120.25.231.55‘;
DECLARE @username SYSNAME=‘SuperSam‘;
DECLARE @password SYSNAME=‘Sues@0271@miki‘;
DECLARE @alias SYSNAME=@server;

EXEC SP_ADDLINKEDSERVER @alias,‘‘,‘SQLOLEDB‘,@server;
EXEC SP_ADDLINKEDSRVLOGIN @alias,‘false‘,NULL,@username,@password;

EXEC(‘SELECT * FROM [‘ + @alias + ‘].[master].[dbo].[sysdatabases]‘);

EXEC SP_DROPLINKEDSRVLOGIN @alias,NULL;
EXEC SP_DROPSERVER @alias;