使用opendatasource,写ip即可: SELECT * FROM OPENDATASOURCE('SQLOLEDB','Data Source=192.168.0.12;database=mydb;user id=sa;Password=1').mydb.dbo.table1