SQL Server 空间和链接服务器

SQL Server 空间和链接服务器

sql
-- 创建一个空间数据表
CREATE TABLE SpatialData (
    ID INT PRIMARY KEY,
    Location GEOGRAPHY
)
-- 插入一些示例数据
INSERT INTO SpatialData (ID, Location)
VALUES (1, geography::STPointFromText('POINT(1 1)', 4326)),
       (2, geography::STPointFromText('POINT(2 2)', 4326)),
       (3, geography::STPointFromText('POINT(3 3)', 4326))
-- 查询距离某个点最近的位置
DECLARE @targetPoint GEOGRAPHY = geography::STPointFromText('POINT(0 0)', 4326)
SELECT TOP 1 ID, Location.STDistance(@targetPoint) AS Distance
FROM SpatialData
ORDER BY Location.STDistance(@targetPoint)
-- 创建一个链接服务器
EXEC sp_addlinkedserver
    @server = 'OracleServer',
    @srvproduct = 'Oracle',
    @provider = 'OraOLEDB.Oracle',
    @datasrc = 'OracleServerName'
-- 查询链接服务器上的数据
SELECT *
FROM OracleServer..OracleSchema.TableName