22,210
社区成员
发帖
与我相关
我的任务
分享
CREATE TABLE dbo.AA (
JC_ID INT IDENTITY (1, 1),
XN VARCHAR (20) NOT NULL,
XQ tinyint NOT NULL,
KCMC VARCHAR (150) NOT NULL,
ISBN VARCHAR (50) NOT NULL,
JCMC VARCHAR (200) NOT NULL,
CBS VARCHAR (150) NOT NULL,
BB VARCHAR (50) NOT NULL,
JCZZ VARCHAR (150) NOT NULL,
XBX VARCHAR (20) NOT NULL,
BZ VARCHAR (200) NULL,
CONSTRAINT PK_AA PRIMARY KEY (XN, XQ, ISBN)
);
CREATE TRIGGER dbo.AA_tri ON [dbo].BB
FOR INSERT
AS
BEGIN
INSERT INTO dbo.AA
( XN,XQ,KCMC,ISBN,JCMC,CBS,BB,JCZZ,XBX
)
SELECT DISTINCT XN,XQ,开设课程,教材ISBN,教材名称,出版社,版别,作者,选必修
FROM inserted AS I
WHERE NOT EXISTS (SELECT 1 FROM dbo.AA WHERE xn = I.xn AND xq=I.xq AND ISBN = I.[教材ISBN])
END
SELECT [name] AS triggerName
,OBJECT_NAME(t.parent_id) AS tableName
,t.modify_date
,t.is_disabled
FROM sys.triggers AS t
执行了把截图贴出来看一下