这个SQL语句因该怎么改改,帮我看一下,谢谢!!!

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"

Published At
Categories with Web编程
comments powered by Disqus