--注,该比较到天,如果要比较到小时甚至分秒,请自行更改datediff参数 CREATE PROCEDURE Agent_CheckCustomerIsFeeOut ( @CustomerID int ) AS begin declare @maxdate datetime select @maxdate=max(jfjzdate) from table where customerid=@customerid if datediff(d,getdate(),@maxdate)>0 print '过期' else print '不过期' GO
CREATE PROCEDURE Agent_CheckCustomerIsFeeOut
(
@CustomerID int
)
AS
begin
declare @maxdate datetime
select @maxdate=max(jfjzdate) from table where customerid=@customerid
if datediff(d,getdate(),@maxdate)>0
print '过期'
else
print '不过期'
GO