/************************************************************************
删除过期分钟平均值
************************************************************************/
CREATE PROCEDURE CalDelDays
@SaveDays INT
AS
DECLARE @DayValue CHARACTER
delete from MinuteAveData where DATEDIFF(day, CAST(RecdYear AS varchar(4))
+ '-' + RIGHT('0' + CAST(RecdMonth AS varchar(2)), 2)
+ '-' + RIGHT('0' + CAST(RecdDay AS varchar(2)), 2), GETDATE())>@SaveDays
GO有点牵强,有更好方法吗?谢谢
删除过期分钟平均值
************************************************************************/
CREATE PROCEDURE CalDelDays
@SaveDays INT
AS
DECLARE @DayValue CHARACTER
delete from MinuteAveData where DATEDIFF(day, CAST(RecdYear AS varchar(4))
+ '-' + RIGHT('0' + CAST(RecdMonth AS varchar(2)), 2)
+ '-' + RIGHT('0' + CAST(RecdDay AS varchar(2)), 2), GETDATE())>@SaveDays
GO有点牵强,有更好方法吗?谢谢
日期怎么不用datetime或smalldatetime?
datediff(day,a,getdate())>2用实际值代替a,不能用别名a一楼可以