利用VB开发的SQL Server2000应用程序

--创建触发器，当向Charge中插入记录时，card中的相应余额增加 CREATE TRIGGER Tri_Insert_Charge ON Charge FOR INSERT AS DECLARE @ID char(10) DECLARE @Money_amount money SELECT @ID=卡号,@Money_amount=金额 FROM INSERTED UPDATE Card SET 余额=余额+@Money_amount WHERE 卡号=@ID GO --创建触发器，当向Consume_Sell中插入记录时，card中的相应余额减少 CREATE TRIGGER Tri_Insert_Consume_Sell ON Consume_Sell FOR INSERT AS DECLARE @ID char(10) DECLARE @Price money SELECT @ID=卡号,@Price=金额 FROM INSERTED UPDATE Card SET 余额=余额-@Price WHERE 卡号=@ID GO