declare @h int, @hr int;

declare @t1 table (s nvarchar(max));
declare @t2 table (s varchar(max) collate Latin1_General_CI_AS);
declare @t3 table (s varchar(max) collate Cyrillic_General_CI_AS);

exec @hr = sp_OACreate 'WinHttp.WinHttpRequest.5.1', @h output;
if @hr <> 0 exec sp_OAGetErrorInfo @h;

exec @hr = sp_OAMethod @h, 'Open', null, 'GET', N'https://www.mos.ru', 'false';
if @hr <> 0 exec sp_OAGetErrorInfo @h

exec @hr = sp_OAMethod @h,'Send';
if @hr <> 0 exec sp_OAGetErrorInfo @h;

insert into @t1
 exec @hr = sp_OAGetProperty @h, N'ResponseText';
if @hr <> 0 exec sp_OAGetErrorInfo @h;

insert into @t2
 exec @hr = sp_OAGetProperty @h, N'ResponseText';
if @hr <> 0 exec sp_OAGetErrorInfo @h;

insert into @t3
 exec @hr = sp_OAGetProperty @h, N'ResponseText';
if @hr <> 0 exec sp_OAGetErrorInfo @h;

exec @hr=sp_OADestroy @h;
if @hr <> 0 exec sp_OAGetErrorInfo @h;
   
select substring(s, charindex('<title', s), charindex('<title', s) + 100) from @t1 where s like '%charset=UTF-8%';
select substring(s, charindex('<title', s), charindex('<title', s) + 100) from @t2 where s like '%charset=UTF-8%';
select substring(s, charindex('<title', s), charindex('<title', s) + 100) from @t3 where s like '%charset=UTF-8%';