这条语句执行怎么没效果啊???
create trigger xx
on dbo.brokeblno for update
as
declare @ch_flag char
declare @broke_code char
select @ch_flag=ch_flag,@broke_code=broke_code
from brokeblno
if @ch_flag='0'
update ikeydemo.dbo.ikey
set isstopped=1
where vch_code=@broke_code
else
update ikeydemo.dbo.ikey
set isstopped=0
where vch_code=@broke_code
create trigger xx
on dbo.brokeblno for update
as
declare @ch_flag char
declare @broke_code char
select @ch_flag=ch_flag,@broke_code=broke_code
from brokeblno
if @ch_flag='0'
update ikeydemo.dbo.ikey
set isstopped=1
where vch_code=@broke_code
else
update ikeydemo.dbo.ikey
set isstopped=0
where vch_code=@broke_code
select @ch_flag=ch_flag,@broke_code=broke_code
from brokeblno 該為select @ch_flag=ch_flag,@broke_code=broke_code
from inserted
on dbo.brokeblno for update
as
declare @ch_flag char
declare @broke_code char
select @ch_flag=ch_flag,@broke_code=broke_code
from inserted
if @ch_flag='0'
update ikeydemo.dbo.ikey
set isstopped=1
where vch_code=@broke_code
else
update ikeydemo.dbo.ikey
set isstopped=0
where vch_code=@broke_code
(所影响的行数为 0 行)
(所影响的行数为 1 行)
或者試試變量賦varchar(20)型的,然後rtrim(ch_flag)
declare @ch_flag varchar(20)
declare @broke_code varchar(20)
select @ch_flag=rtrim(ch_flag),@broke_code=rtrim(broke_code)
from inserted