sql跨库查询

1.配置使用允许跨库查询

EXEC sys.sp_configure N&＃39;show advanced options&＃39;, N&＃39;1&＃39;  RECONFIGURE WITH OVERRIDE
EXEC sys.sp_configure N&＃39;Ad Hoc Distributed Queries&＃39;, N&＃39;1&＃39;
RECONFIGURE WITH OVERRIDE

2.使用跨库查询

SELECT *
FROM OPENDATASOURCE(&＃39;SQLNCLI&＃39;,
&＃39;Data Source&＃61;zyg;UID&＃61;sa;PWD&＃61;sasa;&＃39;)
.gzrs.dbo.AB01