using System;
using System.Data;
using System.Data.sqlClient;
using System.Data.sqlTypes;
using Microsoft.sqlServer.Server;

public partial class StoredProcedures
{
    [Microsoft.sqlServer.Server.sqlProcedure]
    public static int Debug(string s)
    {
        System.Diagnostics.Debug.WriteLine(s);
            return 0;
        }
    }
}

创建密钥和登录名：

USE [master]
CREATE ASYMMETRIC KEY DebugProcKey FROM EXECUTABLE FILE =
'C:\..\sqlServerProject1\bin\Debug\sqlServerProject1.dll'

CREATE LOGIN DebugProcLogin FROM ASYMMETRIC KEY DebugProcKey 

GRANT UNSAFE ASSEMBLY TO DebugProcLogin

将其导入到sql Server中：

USE [mydb]
CREATE ASSEMBLY sqlServerProject1 FROM
'C:\..\sqlServerProject1\bin\Debug\sqlServerProject1.dll' 
WITH PERMISSION_SET = unsafe

CREATE FUNCTION dbo.Debug( @message as nvarchar(200) )
RETURNS int
AS EXTERNAL NAME sqlServerProject1.[StoredProcedures].Debug

然后我可以使用T-sql程序登录

exec Debug @message = 'Hello World'