02 2013 档案

sqlserver 触发器 判断是插入 删除 还是修改 的例子 .
摘要：createTRIGGER[updatetest]ON[dbo].[TEST]FORINSERT,UPDATE,DELETEASbeginDECLARE@IsInsertbit,@IsUpdatebit,@IsDeletebitIFEXISTS(SELECT1FROMinserted)ANDNOTEXISTS(SELECT1FROMdeleted)SET@IsInsert=1ELSESET@IsInsert=0IFEXISTS(SELECT1FROMinserted)ANDEXISTS(SELECT1FROMdeleted)SET@IsUpdate=1ELSESET@IsUpdate=0IFN 阅读全文

posted @ 2013-02-21 08:50 WNFY 阅读(537) 评论(0) 推荐(0)

导航