F22触发器开关 触发器暂停、修改.txt 下载 转存

  • A+
所属分类:网赚之家

1.sql触发器查看
use F22_1
go
select * from sysobjects where xtype='TR'

2.sql触发器内容查看
exec sp_helptext 'TiudG_indentsub'

3.数据更改
update d_Indentsub
set clothingid=SUBSTRING(clothingid,1,9)+'13'+RIGHT(clothingid,2)
where SUBSTRING(clothingid,10,2)<>colorid
and styleid='A129849S1'
and indentid='DH2045-2010-12-15-0002'
select indentid from d_indentsub
where SUBSTRING(clothingid,10,2)<>colorid
and styleid='A129849S1'
group by indentid

 

 

 

 

发货价不等于配货价问题处理
/*修改已经审核登帐的发货单,但必须没有收货,要求没有人有配发货的时候才能关触发器*/
/*关闭触发器,第二步不可以才要停触发器*/
ALTER TABLE d_sell DISABLE TRIGGER Tu_sell
/* sellid=’发货单号’,有多少个就执行多少次,全部改完之后再做下步*/
update d_sell set setchk_sure = 0 where sellid =''
Udate d_sell set set_sure = 0 where sellid = ''

/*如果有已审未登的单据,最好先反审后再执行/
update b set b.phs_price=isnull(c.s_price,0)
from (select sellid,quotaid from d_sell where setchk_sure_sure = 0 and set_sure = 0
and isnull(quotaid,'')<>'') a,
d_sellsub b,d_quotasub c
where a.sellid=b.sellid and isnull(b.phs_price,0)=0 and a.quotaid=c.quotaid and b.clothingid=c.clothingid

/*开启触发器*/
ALTER TABLE d_sell ENABLE TRIGGER Tu_sell

发表评论

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen: