SQL Server 高级技术（七）—— CLR 集成

1、启用 SQL Server CLR

EXEC sp_configure 'sql_enabled',1
RECONFIGURE WITH OVERRIDE

CREATE ASSEMBLY MyCtrStoredProc 
FROM 'Path\\MyCtrStoredProc.dll'
WITH PERMISSION_SET = SAFE;
GO

CREATE PROC ClrMethod 
WITH EXECUTE AS CALLER
AS
EXTERNAL NAME MyCtrStoredProc.CrlMethod
GO 

常用 CLR 类

类	说明
SqlTriggerContext	提供所激发的触发器的上下文信息

SqlConnection conn = new SqlConnnection("context connection = true");
conn.Open();
SqlCOmmand cmd = conn.CreateCommand();
cmd.CommandText = "SELECT * FROM inserted";
reader = cmd.ExecuteReader();
reader.Read();
for(int colNum = 0;colNum < triggerContext.ColumnCount;colNum++)
{
	pipe.Send("Updated Column " + reader.GetName(colNum) + "? " + triggerContext.IsUpdatedColomn(colNum).ToString());	
}