定义一个变量declare @tmp_a int给它赋值SELECT @tmp_a=COUNT(*) FROM TABLE_NAME、这样就是可以了有疑问直接HI我
sql = "SELECT COUNT(*) AS TotalNum FROM TABLE_NAME "rs.open conn sql,1,1...TotalNum = rs("TotalNum")....就可以取到了呀