CREATE TRIGGER 名 on 视图Table
INSTEAD OF update
AS
BEGIN
declare cursor_insert cursor for select c# from inserted where paidflag=1
declare @i int
open cursor_insert
fetch cursor_insert into @i
while @@fetch_status=0
begin
exec PWriteOff @i
fetch cursor_insert into @i
end
close cursor_insert
deallocate cursor_insert
END
go
INSTEAD OF update
AS
BEGIN
declare cursor_insert cursor for select c# from inserted where paidflag=1
declare @i int
open cursor_insert
fetch cursor_insert into @i
while @@fetch_status=0
begin
exec PWriteOff @i
fetch cursor_insert into @i
end
close cursor_insert
deallocate cursor_insert
END
go
INSTEAD OF update
AS
BEGIN
declare cursor_insert cursor for select RefID from inserted where paidflag=1
declare @i int
open cursor_insert
fetch cursor_insert into @i
while @@fetch_status=0
begin
exec PWriteOff @i
fetch cursor_insert into @i
end
close cursor_insert
deallocate cursor_insert
END
go
SELECT Table1.A
FROM Table1
WHERE Table1.RefID=@RefIDDELETE Table1 WHERE Table1.RefID=@RefID