sql="select top 5 * from student where realname<>'"&管理员&"' order by visitcount desc"
因该是...where realname<>'"&管理员&"'...这里有问题,很久没写程序了,不知道这里该如何写!
帮我看下,该怎么写,谢谢!
---------------------------------------------------------------
sql="select top 5 * from student where realname<>'管理员' order by visitcount desc"
---------------------------------------------------------------
aa="管理员"
sql="select top 5 * from student where realname<>'"&aa&"' order by visitcount desc"