ch21.sql

SQLServer2005基础教程,清华大学出版社

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 


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')