heartstill

摘要： 触发器之删除某行字段自动备份 作者：企业库 时间：2010-4-8 10:52:07 起先开始写一个简单的触发器：create TRIGGER trigger_delete_TMaintainon TMaintain for deleteAS BEGINSET NOCOUNT ON;insert into TDeleteMaintainLogselect * from deletedENDGO（这边介绍一下：SET NOCOUNT ON的作用：当 SET NOCOUNT 为 ON 时，不返回计数（表示受 Transact-SQL 语句影响的行数）。当 SET NOCOUNT 为 OFF 时，. 阅读全文

摘要： CREATE TRIGGER deletedBaseproperty ON LD_PE_BASEPROPERTYINSTEAD OF DELETEASBEGIN-- SET NOCOUNT ON added to prevent extra result sets from-- interfering with SELECT statements.SET NOCOUNT ON;insert into LD_PE_BASEPROPERTY_DELETED(peCode,name,sex,photo,pID,married,nation,politic,born,origin,address,po 阅读全文