以分号分隔吗?
strSQL = "delete from classes where cls_num='" & Request.QueryString("ClassNum") & "';delete from tutou where cls_num='" & Request.QueryString("ClassNum") & "' and crs_num='" & Request.QueryString("CourseNum") & "' "
clsDBProcess.ExecuteSQL(Session("Server"), Session("Database"), strSQL)
statement1 go
statement2 go
.......
把sql语句放到arraylist里循环删除
你可以定义数组咯 Dim myStrArray() As String = {Sql语句} 再执行时搞个循环就可以了
//NewsID_SET = "23,35,60,90,101,120,130,11,19,211,";
//NewsID_SET = NewsID_SET.Substring(0, NewsID_SET.Length - 1);
NewsID_SET = NewsID_SET.Remove(NewsID_SET.Length - 1); comm.CommandText = " Delete From tNews Where fNewsID IN (" + NewsID_SET + ")";
comm.ExecuteNonQuery();c#代码 主要看SQL语句。