declare @hr int	
declare @object int
declare @src int
declare @desc varchar(255)

declare @url varchar(1000) 

--
exec @hr=sp_OACreate 'MSXML2.XMLHTTP', @object OUT
if @hr<>0
begin
	exec sp_OAGetErrorInfo @object, @src OUT, @desc OUT
	print @src
	print @desc
end
--
--set @url='http://www.google.ru/search?q="sql.ru"'
set @url='https://www.sql.ru/forum/1042791/zagruzka-koda-html-stranicy-v-peremennuu'
exec @hr=sp_OAMethod @object, 'Open', NULL, 'GET', @url , 0
if @hr<>0
begin
	exec sp_OAGetErrorInfo @object, @src OUT, @desc OUT
	print 'Open'
	print @src
	print @desc
end
--
exec @hr=sp_OAMethod @object, 'send', NULL
if @hr<>0
begin
	exec sp_OAGetErrorInfo @object, @src OUT, @desc OUT
	print 'send'
	print @src
	print @desc
end
--
DECLARE	@Response TABLE ( Response NVarChar(max) )

SET TEXTSIZE 2147483647;

INSERT	@Response
exec @hr=sp_OAGetProperty @object, 'responseText' 

if @hr<>0
begin
	exec sp_OAGetErrorInfo @object, @src OUT, @desc OUT
	print 'responseText'
	print @src
	print @desc
end

select Response from @Response

--
exec @hr=sp_OADestroy @object