Select count(NewsID) from News Where yeah(updatetime)=yeah(date()) and month(updatetime)=month(date()) and day(updatetime)=day(date())
在ACCESS中运行正常,而在sqlserver2000中说yeah不是合法的函数!
请教应该怎么改?
...全文
2210打赏收藏
这条查询语句错在哪里?请教各位大侠
Select count(NewsID) from News Where yeah(updatetime)=yeah(date()) and month(updatetime)=month(date()) and day(updatetime)=day(date()) 在ACCESS中运行正常,而在sqlserver2000中说yeah不是合法的函数! 请教应该怎么改?