sql跨数据库查询

sql跨数据库查询

http://niunan.javaeye.com/blog/387226

数据库1：AAA数据库2：BBB

数据库名和表名之间放两个点

select * from [AAA]..TableA a inner join [BBB]..TableB b on a.AcountID = b.ClientID

注意：必须是单个Sql实例！

http://zhidao.baidu.com/question/87651354.html

 

Select TA.* From A.dbo.products TAjoin B.dbo.price TBOn TA.P_Pid = TB.PidOrder By TB.Pri