For instance, what is:
[dbo].[clr_http_request]
[dbo].[clr_http_request] is the function this article describes. The steps to create the function are noted at the bottom of the article. I'll copy here for convenience. You can also download ClrHttpRequest.zip at the bottom of the article.
To create the function, follow these steps using files found in the attached ClrHttpRequest.zip:
Copy ClrHttpRequest.dll to C:\ on the machine running the SQL Server instanceRun code in clr_http_request.sql to create the function (tweaking as necessary to adjust which database should be used).
Note: This script includes code to change configuration of the SQL Server instance by enabling the CLR integration.
Very kind from you to write the code for me, I copy/pasted it into my SSMS and I receive 1 error on line 9:
Msg 319, Level 15, State 1, Line 9
Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon.
This error is very strange to me. The article was intiially published with a typo in the examples where it was missing an "s" in @response_json, and for me that was giving this error:
Msg 137, Level 15, State 2, Line 28
Must declare the scalar variable "@reponse_json".
Msg 319, Level 15, State 1, Line 28
Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon.
Msg 319, Level 15, State 1, Line 29
Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon.
However, I'm not able to get any similar error with the code I just provided.
If you have created the [dbo].[clr_http_request] function, what happens when you just run this?
SELECT [dbo].[clr_http_request]('GET', 'http://overpass-api.de/api/interpreter?data=[out:json];area[name=%22Auckland%22]-%3E.a;(node(area.a)[amenity=cinema];way(area.a)[amenity=cinema];rel(area.a)[amenity=cinema]; );out;', NULL, NULL, 10000, 0, 0)