ch19 clr.sql

来自「SQL+Server实用简明教程电子教案和实例源文件」· SQL 代码 · 共 40 行

create assembly ti_showinserted
from 'E:\temp\ti_showInserted.dll'
go
DROP ASSEMBLY ti_showinserted
 
USE AdventureWorks 
CREATE ASSEMBLY trigger_insert_showInserted 
FROM 'E:\temp\trigger_insert_showInserted.dll' 
GO 
CREATE TRIGGER trigger_insert_showInserted 
ON HumanResources.Department 
FOR INSERT 
AS EXTERNAL NAME trigger_insert_showInserted.[trigger_insert_showInserted.Triggers].trigger_insert_showInserted
GO 

 


USE master
GO
sp_configure 'show advanced options', 1
GO
RECONFIGURE
GO
sp_configure 'clr enabled', 1
GO
RECONFIGURE
GO






SELECT *
FROM HumanResources.Department

USE AdventureWorks
INSERT INTO HumanResources.Department
VALUES (N'销售部', N'销售和营销组', '2008-08-08')