数据库定时删除数据怎么做
本帖最后由 cgmecgwr 于 2012-12-24 11:29:05 编辑
要方便修改时间的。

时间通常是7天 14天左右

SQL数据库直接再里面弄作业判断 。还是程序里？

程序里那么大的数方便么.

各位用什么方法
[解决办法]

DECLARE @tb_name VARCHAR(100) ,
        @col_name VARCHAR(100) ,
        @sql VARCHAR(1000) ,
        @uchar DATETIME = DATEADD(dd,-7,GETDATE())

DECLARE c CURSOR  FORWARD_ONLY READ_ONLY STATIC 
FOR
SELECT object_name(c.[object_id]) AS tb_name ,c.name AS col_name 
FROM sys.[columns] c ,sys.[tables] AS t 
WHERE c.[object_id]=t.[object_id] 
AND  c.name='id'

OPEN c
FETCH NEXT FROM c INTO @tb_name, @col_name
WHILE @@fetch_status = 0
BEGIN 
SET @sql = 'delete from '+ @tb_name +' where uchar<'''+LTRIM(@uchar)+''''
EXEC(@sql)

FETCH NEXT FROM c INTO @tb_name, @tb_name
END

CLOSE c
DEALLOCATE c