alter TRIGGER Change
ON Map
for Update,insert
AS
declare @AID int,
@SN int
if update(DeleteStatus)
begin
select @AID=A ,@SN=SN from Map
Update Map set SN=2
where A=@AID and SN>@SN
print(@AID)
end
为什么我输出的ID是表里最后一行的ID
ON Map
for Update,insert
AS
declare @AID int,
@SN int
if update(DeleteStatus)
begin
select @AID=A ,@SN=SN from Map
Update Map set SN=2
where A=@AID and SN>@SN
print(@AID)
end
为什么我输出的ID是表里最后一行的ID
ON Map
for Update,insert
AS
begin
declare @AID int, @SN int
if update(DeleteStatus)
begin
select @AID=A ,@SN=SN from inserted
Update Map set SN=2 where A=@AID and SN>@SN
print(@AID)
end
end