不学，昨天跟你说的那个问题研究出来了

用的MSSQL里的触发器，至于定时操作的问题嘛，建个作业
然后去操作这个触发器好了
贴出触发器的SQL脚本吧
比如user这个表
字段如下，ID、name、money、Integral
当money=0时，自动吧Integral修改为0
当money为负数时，把表中这条记录自动删掉
每天晚上12点执行一次

Code:

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tr_UserMoney]') and OBJECTPROPERTY(id, N'IsTrigger') = 1)
drop trigger [dbo].[tr_UserMoney]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[t_User]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[t_User]
GO

CREATE TABLE [dbo].[t_User] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[UserName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[UserMoney] [money] NULL ,
	[Integral] [tinyint] NULL 
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[t_User] WITH NOCHECK ADD 
	CONSTRAINT [PK_t_User] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[t_User] WITH NOCHECK ADD 
	CONSTRAINT [DF_t_User_Integral] DEFAULT (1) FOR [Integral]
GO

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

CREATE TRIGGER [tr_UserMoney] ON dbo.t_User 
FOR  INSERT,UPDATE 
AS

IF UPDATE(UserMoney)
	begin
		update t_User 
		set Integral=0 
		from t_User as A 
		where A.UserMoney=0
		
		delete from t_User
		where UserMoney<0
	end


GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO