摘要：create PROCEDURE [dbo].[Pr_inportEasy_updateORinsert] @P1 varchar(20), @P2 varchar(20), @p3 intAS --创建if EXISTS(select * from inportEasy WHERE inportbName = @P1 and typeI = @P2) begin update inportEasy set quantity = quantity + @p3 WHERE inportbName = @P1 and typeI = @P2 --如果存在就更新 ... 阅读全文

摘要：create trigger T_ComputerNewUpdateChassis on [dbo].[computerNew]for insertas update dbo.inport set quantity = quantity - 1where inportName = (select Chassis from inserted)这是一个插入触发器。这句的语句大意是：但此表插入语句，另外一个表与之相应的项就会减少1参考来自：http://blog.csdn.net/wangboxian/article/details/7303474 阅读全文