3、建立存储过程给AllMoney添加数据: SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE PROCEDURE SP_InsertMoney @MyMoney AS MONEY AS BEGIN SET NOCOUNT ON; INSERT INTO AllMoney(MyMoney) VALUES(@MyMoney) END GO
4、在表AllMoney中建立触发器,更新表LastID SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TRIGGER INSERT_LastID ON AllMoney AFTER INSERT AS BEGIN SET NOCOUNT ON DECLARE @ID AS INT SELECT @ID = MAX(ID) FROM AllMoney UPDATE LastID SET AllMoneyID=@ID END GO