Viewing 15 posts - 1 through 15 (of 72 total)
As the error message indicates, you must obtain an API Key from Google in order to use this service. See: https://developers.google.com/maps/documentation/geocoding/get-api-key
Obtain a key, and then edit the SQL code to...
January 31, 2020 at 5:28 am
Thanks, Phil: EXCEPT and INTERSECT look like the way to go. I recall reading about them but had never actually used them.
October 22, 2019 at 2:08 pm
A very old thread...but it still comes up when searching for this problem.
As the first line of the trigger, add
SET XACT_ABORT OFF;
Then you can trap errors in...
May 28, 2019 at 4:17 pm
This might be a good time for a plug for my SQLVer Version Tracking article. (It might be time for me to write a new article on this that...
March 14, 2019 at 10:27 am
Regarding CREATE vs. ALTER...maybe it is just personal taste, but I don't mind--or maybe even like--the two different commands. We are not just declaring a procedure (or a function, or...
March 14, 2019 at 10:11 am
A good recommendation is to have a simple, but useful header that you use to document the purpose of your procedure and then include comments in places where you...
March 14, 2019 at 9:59 am
The link to the SQL script is in the Resources link at the bottom of the story.
That link goes to: http://www.sqlservercentral.com/Files/Geocode.sql/6085.sql ...but that URL might not...
January 17, 2019 at 6:01 pm
August 30, 2018 at 8:13 am
Thanks, Steve. In this case, the scenario that I described is a bit of an over-simplification. The actual use is deep inside a user-configurable enterprise-class application with automatically-generated CRUD procedures...
July 23, 2018 at 1:40 pm
Ah, thanks. That helps, So to refine the description of the problem:
The compile of the stored procedure fails if an int or uniqueidentifier is passed in. The compile...
July 21, 2018 at 11:44 am
As for those that think using xp_CmdShell for such things constitutes a security...
July 5, 2018 at 11:23 am
A non-visual terminator could be a good solution: \0 (non-visible null aka CHAR(0) ) could work... but certain systems may treat the null as the end of a string or file,...
July 3, 2018 at 1:06 pm
You should be able to append the API key to the URL.
Step 2: Add the API key to your applicationWhen loading...
June 28, 2018 at 10:21 am
Thanks for the article, and for getting us thinking about code performance and readability.
I was struck by something you said:
By doing everything in a single statement,...
March 20, 2018 at 2:53 am
FYI, I have set up a GitHub repository for SQLVer at https://github.com/DavidRueter/SQLVer
Please use the GitHub repository, as the SourceForge repository is being deprecated.<br
January 17, 2017 at 11:30 am