111,098
社区成员
发帖
与我相关
我的任务
分享请发表友善的回复…
发表回复
noyester 2005-03-14
- 打赏
- 举报
SQL
SELECT COUNT(*) AS Expr1
FROM T_BookInfo
WHERE (Book_AddTime BETWEEN CONVERT(DATETIME, '2003-07-12 16:52:18', 102) AND
CONVERT(DATETIME, '2003-7-12 16:52:28', 102))
ACCESS
SELECT count(*)
FROM T_BookInfo
WHERE (Book_AddTime BETWEEN #7/12/2003 4:52:18 PM# AND #7/12/2003 4:52:28 PM#)
SELECT COUNT(*) AS Expr1
FROM T_BookInfo
WHERE (Book_AddTime BETWEEN CONVERT(DATETIME, '2003-07-12 16:52:18', 102) AND
CONVERT(DATETIME, '2003-7-12 16:52:28', 102))
ACCESS
SELECT count(*)
FROM T_BookInfo
WHERE (Book_AddTime BETWEEN #7/12/2003 4:52:18 PM# AND #7/12/2003 4:52:28 PM#)
