sql时间查询
2009-09-24 15:46 LvSir 阅读(535) 评论(1) 编辑 收藏 举报access
datawhere="where ( Address like '%" & Keyword &_
"%' or OrderNo like '%" & Keyword &_
"%' or UserName like '%" & Keyword &_
"%') and AddTime >= #" & StartDate & "# and AddTime <=#" & EndDate & "#"
sqlserver
datawhere="where ( Address like '%" & Keyword &_
"%' or OrderNo like '%" & Keyword &_
"%' or UserName like '%" & Keyword &_
"%') and AddTime >= '" & StartDate & "' and AddTime <='" & EndDate & "'"
为了实现梦想,无论遇到多么大的困难,都不退缩!