www.xiqueer.com:sql="select top 10 * from jjh_news where news_fenlei="&Request("news_fenlei")

来源：百度文库编辑：高校问答时间：2024/04/28 05:55:01

sql="select top 10 * from jjh_news where news_fenlei="&Request("news_fenlei")

想把order by notice_id desc这句加到上面的SQL语句中！
该怎么加啊！

sql="select top 10 * from jjh_news where news_fenlei="& Request("news_fenlei") &" order by notice_id desc

建议不要直接用Request("news_fenlei")在这里容易被注入攻击

sql="select top 10 * from jjh_news where news_fenlei="&Request("news_fenlei")&"order by notice_id desc"

这样即可

sql = "Select top 5 * from news" sql="select top 10 * from jjh_news where news_fenlei="&Request("news_fenlei") 怎么读第二条记录sql="select top 1 * from NEWS whe sql="select top 10 * from news where type='"&request("classid")&"' SqlDataAdapter temp_ada = new SqlDataAdapter("select TOP 17 * from "+Lei+"",temp_con); sql="select * from……" stb="select top 1 id FROM our order by id " asp中 sqlcp="select top 16 * from xnzj order by ArticleID desc"是什么意思 SQL执行：SELECT TOP 1 ZI FROM ST_RSVR_R WHERE STCDT = '72856' ORDER BY YMDHM DESC出错？？？ sql = "Select * From [userinfo] Where userid = '"&userid&"'" ；