And also, another question: why are you creating a database with prime numbers?
As long as I know prime numbers are only used for cryptography, have they any other...

Thank you Jonathan,
I'm interested in your query, I would like to create a database with factorized numbers like this one: http://www.factordb.com/
This database apparently it's only >400MB...

Hi Jonathan, I run your query and it says "Completed" but if then I run:
select * from [dbo].[FastPrimes]
it returns:
Parameters were not supplied...

Hi Solomon, I tell you what is the scenario: 
- you have a few thousands customers, each one with a different security policy 
- in case of priority support you...

FIXED, man.... fixed....
I didn't put the DLL there and I didn't ran the query to enable it. :Whistling:

By the way the error

[code...

I tried this at home on my SQL Server 2017:

Microsoft SQL Server Management Studio                        14.0.17285.0
Microsoft Analysis Services Client Tools                        14.0.1016.283
Microsoft Data Access Components (MDAC)                        10.0.17763.1
Microsoft MSXML                        3.0...

Just to be out of confusion: OPENJSON is working because my archaic query still works.
Look how horrible it is, with that unhealthy "MSXML2.ServerXMLHTTP.6.0", it looks like an old petrol...

SQL Server 2016:

Microsoft SQL Server Management Studio                        13.0.16106.4
Microsoft Analysis Services Client Tools                        13.0.1700.441
Microsoft Data Access Components (MDAC)                        10.0.17134.1
Microsoft MSXML                        3.0 4.0 6.0
Microsoft Internet Explorer                        9.11.17134.0
Microsoft...

Good stuff! 
By the way if I copy/paste your code to SSMS I receive: 
Msg 319, Level 15, State 1, Line 22
Incorrect syntax near the keyword 'with'....

14 years have passed, it's time to update the reply.
Also, this query can:

1) catch the error
2) put the REST call response into a string
3)...

Do this: 

Declare @Object as Int;
DECLARE @hr int
Declare @json as table(Json_Table nvarchar(max))

Exec @hr=sp_OACreate 'WinHttp.WinHttpRequest.5.1', @Object OUT;
IF @hr <> 0...

Thank you, this is the output:

(SELECT COLUMN_NAME INTO ##Resultset
FROM [AdventureWorks2012].[INFORMATION_SCHEMA].[COLUMNS]
WHERE TABLE_NAME = ('AWBuildVersion')
AND COLUMN_NAME != ('*'))

(4 row(s) affected)

(1 row(s)...

Try even with AdventureWorks2012 VS AdventureWorks2014

EXECUTE [dbo].[Compare_Table_Content]
@SourceDB = 'AdventureWorks2012'
,@TargetDB = 'AdventureWorks2014'
,@SourceSchema = 'dbo'
,@TargetSchema = 'dbo'
...