1024欧美最新合集:vb 中的sql
来源:百度文库 编辑:中科新闻网 时间:2024/05/06 07:58:57
SELECT COUNT(*)
FROM table
WHERE (CREATETIME LIKE '20060726%')
Dim strtime As String
strtime = Format(Now, "yyyymmdd")
SELECT COUNT(DISTINCT SRCTERMID) From dbo.VIEW_msgdb_guojian WHERE CREATETIME LIKE '"&strtime&"'
FROM table
WHERE (CREATETIME LIKE '20060726%')
Dim strtime As String
strtime = Format(Now, "yyyymmdd")
SELECT COUNT(DISTINCT SRCTERMID) From dbo.VIEW_msgdb_guojian WHERE CREATETIME LIKE '"&strtime&"'
Dim strtime As String
strtime = Format(Now, "yyyymmdd")
SELECT COUNT(*) From table WHERE CREATETIME LIKE '%strtime%'
或
Dim strtime As String
strtime = Format(Now, "yyyymmdd")
SELECT COUNT(*) From table WHERE CREATETIME LIKE 'strtime%'
回答者:zheng0823 - 经理 四级 7-26 11:11