USE database
go
CREATE TABLE LogMeNow (SomeValue varchar(50), SomeDate datetime default getdate())
go
 
--Here is the proc
CREATE PROC prLog 
@SomeValue varchar(50)
AS
INSERT LogMeNow (SomeValue) VALUES(@SomeValue)
go
 
--And here is the function
Alter FUNCTION fnBla(@id int)
RETURNS varchar(max)
AS
BEGIN
	DECLARE @SQL varchar(500)
	SELECT @SQL = 'osql -SATIFULLAH -E -q "exec dbs..prLog ''fnBla''"'
--	print @SQL
	EXEC master..xp_cmdshell @SQL
	RETURN @SQL
END

--Now call the function a couple of times

SELECT dbo.fnBla(1)
SELECT dbo.fnBla(2)
SELECT dbo.fnBla(4)

using System;
using System.Data;
using System.Data.SqlClient;
using System.Data.SqlTypes;
using Microsoft.SqlServer.Server;


public class CLRFunctions
{
    [SqlFunction(DataAccess=DataAccessKind.Read)]
    public static SqlString fnCSV(SqlString columnName, SqlString tableName, SqlString whereClause)
    {
        //Declare results CSV
        SqlString CSVResults = "";

        //Create Query
        string sqlQuery = "SELECT " + columnName.ToString() + " FROM " + tableName.ToString();
        //Add where clause if applicable
        if (!String.IsNullOrEmpty(whereClause.ToString()))
            sqlQuery += " " + whereClause.ToString();

        //Use the current connection
        using (SqlConnection conn = new SqlConnection("Context Connection=true"))
        {
            conn.Open();
            SqlCommand sqlCommand = new SqlCommand(sqlQuery, conn);
            SqlDataReader sqlDataReader = sqlCommand.ExecuteReader();

            while (sqlDataReader.Read())
            {
                CSVResults += sqlDataReader[columnName.ToString()].ToString() + ",";
            }

            //Trim trailing comma
            if (CSVResults.ToString().Length > 0)
                CSVResults = CSVResults.ToString().Substring(0, CSVResults.ToString().Length - 1);
        }
        return CSVResults;
    }
}

USE [Work]
GO
/****** Object:  UserDefinedFunction [dbo].[fnCSV]    Script Date: 07/11/2008 15:30:04 ******/
CREATE FUNCTION [dbo].[fnCSV](@columnName [nvarchar](4000), @tableName [nvarchar](4000), @whereClause [nvarchar](4000))
RETURNS [nvarchar](max) WITH EXECUTE AS CALLER
AS 
EXTERNAL NAME [CLRCSV].[CLRFunctions].[fnCSV]

CREATE TABLE TestData
(
	ID INT IDENTITY(1,1) NOT NULL PRIMARY KEY,
	DataString NVARCHAR(8) NOT NULL
)

DECLARE @i INT
SET @i = 10000

WHILE @i > 0
BEGIN
	INSERT INTO TestData(DataString)
	SELECT LEFT(NEWID(),8)

	SET @i = @i-1
END