触发器批量分类更新

今天和采购部的黄生讨论需求，报价系统中第一次写入的时候指定默认值。

条件有好几项目，本来应该写入到逻辑层的，实在不想写代码了，就想用触发器搞定吧。批量第一脑子中就想用游标吧，NND难道没有别方法？

想了想用CASE WHEN 好像可以解决：

 

-- ============================= -- Author: <David Gong>   -- Create date: <2011-11-01>   -- Description: <默认值>   -- =============================CREATE TRIGGER [DefaultRemarks] ON [dbo].[Quo_Standardcostdetail] FOR INSERT  AS          BEGIN TRANSACTION   SET NOCOUNT ON update a  set a.Remarks=CASE WHEN b.Description='LCD'     and b.Item is  not null then 'MOQ'                  WHEN b.Description='LCD'     and b.Item is  null then 'Tooling MOQ'                 WHEN b.Description IN ('BL','背光','背光源','铁框','BZ','PCB','托盘')    and b.Item is  null then 'Tooling'                  else null endfrom Quo_Standardcostdetail a,INSERTED  b where a.id=b.idSET NOCOUNT OFFCOMMIT TRANSACTION

测试结果没问题！