Пример хранимой процедуры CLR
Imports System
Imports System.Data
Imports System.Data.Sql
Imports System.Data.SqlTypes
Imports Microsoft.SqlServer.Server

Partial Public Class StoredProcedures
   _
  Public Shared Sub  HelloWorld ()
    SqlContext.Pipe().Send("Hello from this CLR stored procedure")
  End Sub
End Class