难到不难,用触发器来做的话,就是写代码麻烦。安要求,然后看看 触发器的写法就好了亚--下面是一个触发器的例子CREATE TRIGGER trig1
on authors
FOR INSERT, UPDATE, DELETE
AS
SELECT a.au_lname, a.au_fname, x.info
FROM authors a INNER JOIN does_not_exist x
ON a.au_id = x.au_id
on authors
FOR INSERT, UPDATE, DELETE
AS
SELECT a.au_lname, a.au_fname, x.info
FROM authors a INNER JOIN does_not_exist x
ON a.au_id = x.au_id
ON EMP
FOR INSERT, UPDATE
AS
delcalre @sala int
select @sala from inserted
if @sala<1000 RAISERROR (50009, 16, 10)
GO其余类似