我有这段代码给出了这个错误
-- Set the API URL
SET @url = 'https://www.banxico.org.mx/SieAPIRest/service/v1/series/SF43718/dato/oportuno?token=734b37b3a5099a9d2d39d06478d47e359a9568cd6693116d95b710e6b8be0008';
-- Use built-in SQL Server functions to make HTTP request and obtain response
-- Requires SQL Server 2016 or later
DECLARE @json NVARCHAR(MAX);
-- Use sys.dm_exec_query_stats to enable SQL Server to execute external scripts
-- Indb is the database name
USE lndb;
EXEC sp_execute_external_script
@language = N'Python',
@script = N'
import requests
url = "https://www.banxico.org.mx/SieAPIRest/service/v1/series/SF43718/datos/oportuno?token=734b37b3a5099a9d2d39d06478d47e359a9568cd6693116d95b710e6b8be0008"
response = requests.get(url)
json_response = response.text
json_response',
@output_data_1_name = N'json',
@output_data_1 = @json OUTPUT;
-- Parse the JSON response using OPENJSON
DECLARE @usdRate DECIMAL(18, 6);
SELECT @usdRate = value
FROM OPENJSON(@json, '$.bmx.series[0].datos[0].dato')
WITH (value DECIMAL(18, 6) '$');
-- Display the result
SELECT @usdRate AS USDExchangeRate;
消息 297,级别 16,状态 101,过程 sp_execute_external_script,第 1 行 [批处理起始行 0] 用户无权执行此操作。
管理员已经给了我权限
另外什么是 sys.dm_exec_query_stats
您应该请求这项权利: