Create trigger AddRealTimeOrder
on discountmoney
after insert
as
begin tran
declare @id int
select top 1 @id=id from discountmoney order by id desc
declare @orderid nvarchar(max)
select @orderid=ordernumber from discountmoney where
id=@id
delete from realtime
insert into realtime(orderid) values(@orderid)
commit tran
这个是源码，问题是我想知道我插入的是那条数据，并将该数据增加到新到realtime表中，应该如何做呢？
