示例18-1.sql

来自「SQL Server 业已成为最为流行的几大数据库之一」· SQL 代码 · 共 17 行

USE S_C_SC
GO
Alter Database S_C_SC
SET TRUSTWORTHY ON
Go
CREATE ASSEMBLY testCLRTrigger
FROM 'D:\sqldemo\testCLRTrigger\testCLRTrigger\bin\Debug\testCLRTrigger.dll'
WITH PERMISSION_SET = UNSAFE
GO
DISABLE TRIGGER trPreventAnyTriggerOption ON DATABASE
GO
CREATE TRIGGER dbo.trInsertTableCourse
ON dbo.COURSE
FOR INSERT
AS EXTERNAL NAME testCLRTrigger.[testCLRTrigger.testCLRTrigger].trTestCLRTrigger
GO