namespace SqlLibTest {
    using Microsoft.SqlServer.Server;
    using System;
    using System.Data;

    public static class SqlLibTest {
        [SqlProcedure()]
        public static void HelloWorld() {
            SqlPipe pipe = SqlContext.Pipe;
            pipe.Send("Hello World!");
            SqlDataRecord record = new SqlDataRecord(new SqlMetaData("ID", SqlDbType.Int), new SqlMetaData("value", SqlDbType.VarChar, 100));
            pipe.SendResultsStart(record);
            for(int i = 1; i <= 15; i++) {
                record.SetInt32(0, i);
                record.SetString(1, string.Format("Hello World {0}!", i));
                pipe.SendResultsRow(record);
            }
            pipe.SendResultsEnd();
        }
    }
}

/*
 
-- T-SQL statements to use:

CREATE ASSEMBLY [SqlLibTest]
FROM 'C:\Server Accessable Location\SqlLibTest.dll';

CREATE PROCEDURE [dbo].[HelloWorld]
AS EXTERNAL NAME [SqlLibTest].[SqlLibTest.SqlLibTest].[HelloWorld];

EXEC [dbo].[HelloWorld];

*/