sql2000触发器没有效率

2010-10-18 10:47:06 153 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

pandas，构造MultiIndex的四种方法：from_tuples、from_arrays、from_product、from_frame 1、from_tuples：通过 “元组对” 构造MultiIndex """ 一对元组，为一个索引 """ tuples = [(1, 'red'), (1, 'blue'), (2, 'red'), (2, 'blue')] pd.MultiIndex.from_tuples(tuples, names=('number', 'color')) 2、from_arrays：通过 “列表元素的组合” 构造MultiIndex """ 列中表的元素，按位置对应组合，形成索引 """ arrays 阅读详情

CREATE TRIGGER tr_mys_yz_update ON dbo.mys_yz 

FOR  UPDATE 

AS



if ( update( sfbz) )

begin



  --更新手术的收费标志

  Update a set sfbz = '1'  

  from ss_sqd a inner join inserted b on a.djh = b.sqdbh and b.sqdfl = 'ss' 

      inner join deleted  c on b.yzh = c.yzh and b.yzxh = c.yzxh and isnull( b.sfbz,'0' ) = '0' and isnull(c.sfbz,'0' ) = '1'



  --更新检验的收费标志

  Update a set sfbz = '1'  

  from jy_jyd  a inner join inserted b on a.jydh = b.sqdbh and b.sqdfl = 'jy' 

      inner join deleted  c on b.yzh = c.yzh and b.yzxh = c.yzxh and isnull( b.sfbz,'0' ) = '0' and isnull(c.sfbz,'0' ) = '1'

   

--更新检查的收费标志

Update a set sfbz = '1'  

  from jc_jcd  a inner join inserted b on a.djh = b.sqdbh and b.sqdfl = 'jc' 

      inner join deleted  c on b.yzh = c.yzh and b.yzxh = c.yzxh and isnull( b.sfbz,'0' ) = '0' and isnull(c.sfbz,'0' ) = '1'

 

end