触发器问题

create trigger tr_IssueProduct on IssueProduct
for insert
as 
begin
declare @invseriesnr varchar(13)
select @invseriesnr=invseriesnr from inserted
declare @prodnr varchar(30)
select @prodnr=prodnr from inserted

update IssueProduct set qty=ceiling(qty) 
where invseriesnr=@invseriesnr and prodnr=@prodnr and 
end
我写了个触发器，但这个触发器是对所以的插入到这个表的小数都进位， 我想达到只让414-% （414是一个分类，百分号是变动的 ）这个分类的小数进位，其它的不进位一样可以插入到这个表，应该如何写！

按你的需求加个限制分类的条件。

SQL code

create trigger tr_IssueProduct on IssueProduct
for insert
as  
begin
update t set qty=(case when type='414-%' then ceiling(qty) else qty end)
from IssueProduct t
where exists(select 1 from inserted where invseriesnr=t.invseriesnr and prodnr=t.prodnr)
end

晴天大大V5

SQL code

create trigger tr_IssueProduct on IssueProduct
for insert
as 
begin

update a 
set qty=ceiling(qty) 
FROM INSERTED AS i,IssueProduct AS a
WHERE i.prodnr=a.prodnr AND i.invseriesnr=a.invseriesnr AND a.分類 LIKE '414-%'
end

提示错误207:无效的资料行名称type 把这个改成字段prodnr 这个触发器没起作用 因为414-%是属于prodnr字段的。

试试
SQL code

create trigger tr_IssueProduct on IssueProduct
for insert
as  
begin
declare @invseriesnr varchar(13)
select @invseriesnr=invseriesnr from inserted
declare @prodnr varchar(30)
select @prodnr=prodnr from inserted

update IssueProduct set qty=ceiling(qty)  
where invseriesnr=@invseriesnr and prodnr like '414-%'
end

CREATE trigger tr_IssueProduct on IssueProduct
for insert
as 
begin
declare @invseriesnr varchar(13)
select @invseriesnr=invseriesnr from inserted
declare @prodnr varchar(30)
select @prodnr=prodnr from inserted

update IssueProduct set qty=(case when prodnr like '414-%' then ceiling(qty) else qty end)
where invseriesnr=@invseriesnr and prodnr=@prodnr 
end
改成这样就可以了。