STDistance, geography
-- 상점 테이블 CREATE TABLE Store ( Id INT Primary Key, Name NVARCHAR(100), Location GEOGRAPHY ) -- 상점 위치 저장 INSERT INTO Store (Id, Name, Location) VALUES (1, N'KFC', geography::Parse('POINT(126.975970 37.571482)') ) INSERT INTO Store (Id, Name, Location) VALUES (2, N'교보문고', geography::Parse('POINT(126.977831 37.571100)') ) INSERT INTO Store (Id, Name, Location) VALUES (3, N'다니엘약국', geography::Parse(..
더보기