SQL Server 高级技术（七）—— CLR 集成_sqlserver使用clr integration

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 
1
2
3
4
5
6
7
8
9
10
11
12
13

常用 CLR 类

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());	
}
1
2
3
4
5
6
7
8
9
10