declare @url varchar(1000)
declare @int int
SET @int = 42
SET @url='http://ccv.viatelecom.com/wcbr/wsRealTimeMode.php?adm=10764&sid=3112&nocall=' + CONVERT(varchar,@int)

declare @results varchar(max)

SELECT @results = dbo.CLR_WebQuery(@url)
print @results

/*
OK
#0 appels effectifs / #42 / #0
*/

 'requires
    'Imports System.Net
    <Microsoft.SqlServer.Server.SqlFunction()>
    Public Shared Function CLR_WebQuery(ByVal URL As String) As SqlChars ' varchar(8000) = SqlString, SqlChars=varchar(max)
        Dim request As WebRequest = HttpWebRequest.Create(URL)
        Using response As WebResponse = request.GetResponse()
            Using dataStream As Stream = response.GetResponseStream()
                Using reader As New StreamReader(dataStream)
                    Dim responseFromServer As String = reader.ReadToEnd()
                    Return New SqlChars(New SqlString(responseFromServer))
                End Using
            End Using
        End Using
        request = Nothing
    End Function

ALTER DATABASE Test SET TRUSTWORTHY ON

Use Test;
GO
declare @url varchar(1000)
declare @int int
SET @int = 59
SET @url='http://ccv.viatelecom.com/wcbr/wsRealTimeMode.php?adm=10764&sid=3112&nocall=' + CONVERT(varchar,@int)

declare @results varchar(max)

SELECT @results = dbo.CLR_WebQuery(@url)
print @results