sqlstr = "DELETE student.*,student.Id_num FROM student WHERE student.Id_num=100;
deleteuser = new System.Data.OleDb.OleDbCommand(sqlstr, myConn);
deleteuser.Connection.Open();
deleteuser.ExecuteNonQuery();如果我想在DELETE student.*,student.Id_num FROM student WHERE student.Id_num=100前再加一条SQL语句,请问用什么语法连接两条SQL语句一起写入sqlstr?
谢谢
deleteuser = new System.Data.OleDb.OleDbCommand(sqlstr, myConn);
deleteuser.Connection.Open();
deleteuser.ExecuteNonQuery();如果我想在DELETE student.*,student.Id_num FROM student WHERE student.Id_num=100前再加一条SQL语句,请问用什么语法连接两条SQL语句一起写入sqlstr?
谢谢
INSERT INTO 目标表 SELECT * FROM 源表 WHERE 条件表达式
DELETE * FROM 源表 WHERE 条件表达式不存在的话
SELECT * INTO 目标表 FROM 源表 WHERE 条件表达式
DELETE * FROM 源表 WHERE 条件表达式两条条件相同执行前启动事务
执行后提交事务