alter TRIGGER TourSpotSN ON tb_Base_NearbySpotMap for Update AS declare @ID int, @SN int if Update(nbsm_DeleteStatus) begin select @ID=nbsm_ID,@SN=nbsm_TourSpotSN from tb_Base_NearbySpotMap Update tb_Base_NearbySpotMap set nbsm_TourSpotSN=100 where nbsm_ID=@ID end 帮我看一下 谢谢
create tigger f on tb for update as begin if updaate(nbsm_DeleteStatus) update tb set nbsm_TourSpotSN=-1 end
DROP TABLE Tp CREATE TABLE tp ( id INT IDENTITY, nbsm_DeleteStatus VARCHAR(10), nbsm_TourSpotSN INT )ALTER TRIGGER trig_Tp ON tp FOR UPDATE AS BEGIN IF Update(nbsm_DeleteStatus) BEGIN UPDATE tP SET nbsm_TourSpotSN = -1 END END
INSERT INTO tp SELECT 'AA',5
SELECT * FROM tp t
UPDATE TP SET nbsm_DeleteStatus='BB' , nbsm_TourSpotSN=6 WHERE ID=1id nbsm_DeleteStatus nbsm_TourSpotSN ----------- ----------------- --------------- 1 BB -1(1 row(s) affected)
ON tb_Base_NearbySpotMap
for Update
AS
declare @ID int,
@SN int
if Update(nbsm_DeleteStatus)
begin
select @ID=nbsm_ID,@SN=nbsm_TourSpotSN from tb_Base_NearbySpotMap
Update tb_Base_NearbySpotMap set nbsm_TourSpotSN=100
where nbsm_ID=@ID end
帮我看一下 谢谢
for update
as
begin
if updaate(nbsm_DeleteStatus)
update tb set nbsm_TourSpotSN=-1
end
CREATE TABLE tp
(
id INT IDENTITY,
nbsm_DeleteStatus VARCHAR(10),
nbsm_TourSpotSN INT
)ALTER TRIGGER trig_Tp
ON tp
FOR UPDATE
AS
BEGIN
IF Update(nbsm_DeleteStatus)
BEGIN
UPDATE tP
SET nbsm_TourSpotSN = -1
END
END
INSERT INTO tp SELECT 'AA',5
SELECT * FROM tp t
UPDATE TP SET nbsm_DeleteStatus='BB' , nbsm_TourSpotSN=6
WHERE ID=1id nbsm_DeleteStatus nbsm_TourSpotSN
----------- ----------------- ---------------
1 BB -1(1 row(s) affected)