sql server 实现行级触发器方法

sql server本身没有行级触发器，可用游标实现

create trigger delticket
on ticket
after delete 
as
begin 
	declare @Tno char(20)
	declare cur cursor local forward_only for
	select [Tno]
	from deleted
	open cur
	fetch next from cur into @Tno
	while @@FETCH_STATUS=0
		begin update train
			set train.seatnum=train.seatnum-1
			from train
			where train.Tno=@Tno
			fetch next from cur into @Tno
		end	
	close cur
	deallocate cur
end