为什么不能用GetDate()函数
casho 2003-12-26 03:58:09 CREATE FUNCTION house_isOvered (@house_id int)
RETURNS bit
BEGIN
Declare @over_time datetime
Select top 1 @over_time = (dateadd(year,[house_period],[house_datetime])) from property_house where house_id=@house_id
if @over_time >GetDate()
return 1
return 0
END