CREATE TRIGGER Up_Del_Telecode on codepos for update ,delete
as
begin
declare @telecode varchar(40)
declare @equipid varchar(40)
declare @newtelecode varchar(40)
select @newtelecode = telecode,@equipid = equipid from inserted
select @telecode=telecode from codpos where equipid=@equipid
IF UPDATE (telecode) begin
update codepos set telecode = @newtelecode where telecode = @telecode
end
end
as
begin
declare @telecode varchar(40)
declare @equipid varchar(40)
declare @newtelecode varchar(40)
select @newtelecode = telecode,@equipid = equipid from inserted
select @telecode=telecode from codpos where equipid=@equipid
IF UPDATE (telecode) begin
update codepos set telecode = @newtelecode where telecode = @telecode
end
end