下面的SQL语句select * from [viwBasket] where tblUser='" + (string

来源：学生作业帮编辑：搜狗做题网作业帮分类：综合作业时间：2024/06/03 17:18:59

下面的SQL语句
select * from [viwBasket] where tblUser='" + (string)Session["User"] + "'order by ID desc"其中的 [viwBasket]是什么意思,我的数据库里并没有这张表,为什么要加个中括号.

select * from [viwBasket] where tblUser='" + (string)Session["User"] + "'order by ID desc"其中的 [viwBasket]

这个是查询sql数据库中表名为viwBasket中的所有值,条件是tblUser='" + (string)Session["User"],并按照ID降序排列.

由于viwBasket是数据库的关键字,或是已被定义的,需加中括号,例如表名为User的也需要加[]

语句为select * from [user]

下面的SQL语句select * from [viwBasket] where tblUser='" + (string String sql = "select * from tb_consumer where account='" + a 改写SQL语句,将下面这个语句改写成SELECT-FROM-WHERE的形式. SQL 语句 "SELECT * FROM {{table}} WHERE `fleet_end_time` string sql = "select * from user where user_name='" +t1.Text sql 语句中 select * from table where 2=1 的where2=1有什么意思和作用 SQL语句:SELECT * from stu where name like "%伟%";的作用是:_________ sql如何取交集有这样两条sql语句select distinct id from a where id='123'se SQL语句理解 select * from B where (select count(1) as num from A SQL >select count(*) from Teacher where teacherCode=? and te sql="select discount_value from shop_discount where discount 请教sql语句,像select …from wsdy_zb t where t.id =:id order by no