UC知道这个insert语句有问题么？
来源：百度知道 编辑：UC知道 时间：2024/07/02 16:50:20
string query = "insert into user(id,upass) values(vieri,password)";
string strConn = "略";//这句没问题
SqlConnection conn = new SqlConnection(strConn);
conn.Open();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = query;
cmd.Connection = conn;
SqlDataReader aaa = cmd.ExecuteReader();
aaa.Close();
conn.Close();
最后提示是，user附近有错误，错误是什么啊？
string strConn = "略";//这句没问题
SqlConnection conn = new SqlConnection(strConn);
conn.Open();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = query;
cmd.Connection = conn;
SqlDataReader aaa = cmd.ExecuteReader();
aaa.Close();
conn.Close();
最后提示是，user附近有错误，错误是什么啊？
string query = "insert into user(id,upass) values(vieri,password)";这句可能有错误
原因如下:
(1)vieri和password如果是个变量应写为
string query = "insert into user(id,upass) values('"&vieri&"','"&password&"')";
注:如果变量为字符串应写为'"&变量名&"',若为数字应为"&变量名&",上面我把两个变量都作为字符串了.有的程序里是用"+"而不是用"&",请注意!!
(2)vieri和password如果是个常量量应写为
string query = "insert into user(id,upass) values('vieri','password')";
注:在这里我还是把两个量作为字符串了,如不是请自己改过来
改为
string query = "insert into [user] (id,upass) values(vieri,password)";
错误的原因是 使用了user关键字，用综括号把user引起来即可
insert into [user] (id,upass) values(vieri,password)
除此之外还有以下SQL关键字：
action add aggregate all
alter after and as
asc avg avg_row_length auto_increment
between bigint bit binary
blob bool both by
cascade case char character
change chec