![[MSSQL] Geometry Query](https://img1.daumcdn.net/thumb/R750x0/?scode=mtistory2&fname=https%3A%2F%2Fblog.kakaocdn.net%2Fdn%2FbxQEtc%2FbtsBqhyaiVL%2FDZzRH4qQMpcXxy5o6SWG51%2Fimg.png)
Database2022. 9. 14. 20:55[MSSQL] Geometry Query
Geometry 데이터 형식 쿼리 STContains STContains(geometry 데이터 형식) geometry 인스턴스에 다른 geometry 인스턴스가 완전히 포함되어 있으면 1을 반환합니다. 그렇지 않으면 0을 반환합니다. DECLARE @g geometry; DECLARE @h geometry; SET @g = geometry::STGeomFromText('POLYGON((-122.358 47.653, -122.348 47.649, -122.348 47.658, -122.358 47.658, -122.358 47.653))', 4326); SET @h = geometry::STGeomFromText('POINT(-122.358 47.656)', 4326); SELECT @g.STContai..