?? tjy_delete.sql
字號:
create trigger tjy_delete on zzyjy
for delete
as
begin
update zzyxs
set 借書量=借書量-1
where zzyxs.借書證號 in
(select deleted.借書證號
from deleted)
update zzybook
set 庫存量=庫存量+1
where zzybook.ISBN in
(select deleted.ISBN
from deleted)
end
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -