高校问答iphone6plus官换机价格:问！Sql语句的变量类型问题！
来源：百度文库 编辑：高校问答 时间：2024/05/10 10:10:57
sql语句中如果要引用数值型的变量怎么做呢？比如这一句中的newid就是个数值型变量。怎么写才正确呢？
rs3.open "select top 10 * from news where class_id=newid order by id desc",conn,1,1
rs3.open "select top 10 * from news where class_id=newid order by id desc",conn,1,1
rs3.open "select top 10 * from news where class_id="+cstr(newid)+" order by id desc",conn,1,1
如果你说的newid是sql语句的系统变量,newid应该是随机值,并不是数值
rs3.open "select top 10 * from news where class_id="&newid&" order by id desc",conn,1,1