Question

asp 中用SQL 语句先判断数据库中某一个表是否为空应该怎么写?

strSql="select count(*) from V_news
set rs = Server.CreateObject("ADODB.Recordset")
rs.open strSql, my_Conn, adOpenKeyset, dLockOptimistic, adCmdText
if rs.EOF=0 then
……
else
……
end if
set rs = nothing '清空rs值

这样是不是就可以了？

Answer 1

sql="select count(*) as cc from V_news"
set rs = server.createobject("adodb.recordset")
rs.open sql,conn,1,1
if rs("cc")=0 then
response.write"V_news中没有数据"
end if
rs.close
set rs=nothing

Answer 2

if rs.eof and rs.bof then
...

Answer 3

rs.recordcount = 0