触发器的
if(update(sys_state))
begin
if @sys_state=0
begin
delete yuyue where fid=@id and [type]='sell'
delete list where fid=@id and [type]='sell'
end
end
有触发器的,是不是触发器导致的?
查询语句
select top 5 * from Sell where sys_state=1 and State=1 and xs_state=1 and pub=15 order by Date desc
更新语句
update Sell set sys_state=0 where ID=1