触发器

作用：

学生表一插入数据就将插入的信息在插入到充值表中

代码如下：

create TRIGGER [dbo].[Auto save_registration]
   ON  [dbo].[Student_Info]
   AFTER Insert               
AS 
BEGIN
declare @CardNo varchar(20),      
          @StudentNo varchar(20),
          @Cash decimal(18, 2),
          @RegisterDateTime datetime,
          @UserID varchar(20),
          @State varchar(20),
          @Type varchar(20)
		  select @CardNo=CardNo from inserted
		  select @StudentNo=StudentNo from inserted
		  select @Cash=Cash from inserted
		  select @RegisterDateTime=RegisterDateTime from inserted
		  select @UserID=UserID from inserted
		  select @State=State from inserted
		  select @Type=Type from inserted

	SET NOCOUNT ON;
	insert into ReCharge_Info(CardNo,StudentNo,AddMoney,DateTime,UserID,State,Type) values(@CardNo,@StudentNo,@Cash,@RegisterDateTime,@UserID,@State,@Type)
	
 
END