图书表
BookID char(15) Unchecked
ISBN char(10) Checked
BookName nvarchar(20) Checked
Author nvarchar(20) Checked
PulishDate datetime Checked
Pulisher nvarchar(20) Checked
IsCancel int Checked
BookTypeID char(10) Checked注销表
CancelID int Unchecked
BookID char(15) Checked
CancelDate datetime Checked
for insert
as
--语句
for insert
asupdate 图书表
set IsCancel = 1 --1代表注销,具体是什么值自己改
from 图书表,inserted i
where i.BookID=图书表.BookID