Listing 1: Sample CLR Stored Procedure

Imports System
Imports System.Data
Imports System.Data.Sql
Imports System.Data.SqlTypes
Imports Microsoft.SqlServer.Server

Partial Public Class StoredProcedures
  <Microsoft.SqlServer.Server.SqlProcedure()> _
  Public Shared Sub  HelloWorld ()
    SqlContext.Pipe().Send("Hello from this CLR stored procedure")
  End Sub
End Class