1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32
| CREATE TABLE T (Nom VARCHAR(8) PRIMARY KEY NOT NULL,
G GEOGRAPHY)
INSERT INTO T VALUES ('Capitole', GEOGRAPHY::STGeomFromText
(
'POLYGON
(
(43.604832 1.442787,43.60492 1.443754,43.603922 1.443987,43.603823 1.443028,43.604832 1.442787)
)',
4326
));
INSERT INTO T VALUES ('Croix', GEOGRAPHY::Point(1.443304, 43.604386, 4326));
INSERT INTO T VALUES ('HotelDV', GEOGRAPHY::Point(1.444323, 43.604526, 4326));
SELECT * FROM T
SELECT CAST(T1.G.STIntersection(T2.G) AS VARCHAR(max))
FROM T AS T1
CROSS JOIN T AS T2
WHERE T1.Nom = 'Capitole'
AND T2.Nom = 'Croix'
SELECT CAST(T1.G.STIntersection(T2.G) AS VARCHAR(max))
FROM T AS T1
CROSS JOIN T AS T2
WHERE T1.Nom = 'Capitole'
AND T2.Nom = 'HotelDV' |
Partager