set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
ALTER trigger [chuku]
on [dbo].[df_StockOut_Detail]
for insert
as
declare @goodsno varchar(50),@goodscount money ,@chukudate datetime,@Total money,@Price money
select @goodsno=goodsno,@goodscount=Count,@Total=Total,@Price=price from INSERTED
select @chukudate=getdate();
insert into sun_StockOut(GoodsNO,Count,Date,Total,Price)values(@goodsno,@goodscount,@chukudate,@Total,@Price)