Querying geography data type from different servers

375 Views Asked by At

I'm on server1, it has a lot of dbs. I need to be able to query (select) geography type from different dbs specified. This works fine

SELECT GeoField=geography::STGeomFromText(GeoField,4326)
FROM 
(SELECT convert(nvarchar(max),GeoField) as GeoField from [server1].dbA.dbo.MyTable) as t

Now I need to query from server1, servers2 db. server2 is linked on server1. I can use this query which works fine

SELECT GeoField=geography::STGeomFromText(GeoField,4326)
FROM OPENQUERY([server2],
'SELECT GeoField=convert(nvarchar(max),GeoField) from dbB.dbo.MyTable')

All queries are run from server1. Constraint: I can't add server1 as a linked server on server1.

Question: how can I use one query to query both my current server (server1) and linked server (server2) by simply changing servername and dbname, and not use two different queries specified above?

0

There are 0 best solutions below