赞
踩
- create trigger T_addCurrencyNum
- on Sales.Currency --在Sales.Currency表中新建触发器
- for insert --规定触发器种类为INSERT
- as
- update Sales.CurrencyRate set ModifiedDate=ModifiedDate+1 --在Currency表修改后,与该表相关的CurrencyRate表中ModifiedDate值加一
- create trigger T_addCurrencyNum
- on Sales.Currency --在Sales.Currency表中新建触发器
- for insert --规定触发器种类为INSERT
- as
- update Sales.CurrencyRate set ModifiedDate=ModifiedDate+1 --在Currency表修改后,与该表相关的CurrencyRate表中ModifiedDate值加一
- create trigger T_deleteName
- on Sales.Currency
- for delete
- as
- select Name from deleted --deleted是一个临时表,用以存储删除的数据
delete from Sales.Currency where Name='CN' --提示删除‘CN’
- create trigger T_updateCode
- on Sales.Currency
- for update
- as
- if(update(CurrencyCode)) --如果对表CurrencyCode进行修改
- begin
- print 'you can not modify the CurrencyCode!'
- rollback transaction --回滚操作,即对执行失败的语句进行撤销,返回原表
- end
- else
- print 'success!'
update Sales.Currency set CurrencyCode='SYJ' where Name='Kroon'
- create trigger T_modTable
- on database --数据表级别
- for drop_table,alter_table --不允许drop,alter
- as
- print 'you can not modify the database!'
- rollback
Copyright © 2003-2013 www.wpsshop.cn 版权所有,并保留所有权利。