使用SQL Server 2016如何从Google平台检索纬度和经度。代码不起作用

CREATE PROCEDURE GetLatitudeLongitude
    @address NVARCHAR(100)
AS
BEGIN
    DECLARE @url NVARCHAR(200)
    DECLARE @latitude FLOAT
    DECLARE @longitude FLOAT

    SET @url = 'https://maps.googleapis.com/maps/api/geocode/json?address=' + REPLACE(@address, ' ', '+')

    EXEC sp_OACreate 'MSXML2.ServerXMLHTTP', @obj OUT;
    EXEC sp_OAMethod @obj, 'open', NULL, 'GET', @url, false
    EXEC sp_OAMethod @obj, 'send'
    EXEC sp_OAMethod @obj, 'responseText', @responseText OUTPUT

    EXEC sp_OADestroy @obj

    SELECT @latitude = JSON_VALUE(value, '$.results[0].geometry.location.lat'),
           @longitude = JSON_VALUE(value, '$.results[0].geometry.location.lng')
    FROM OPENJSON(@responseText, '$.results')

    SELECT @latitude AS Latitude, @longitude AS Longitude
END

EXEC GetLatitudeLongitude '北京市朝阳区'