关于ExecuteNonQueryr执行慢的问题
try
{
//创建一个SqlConnection对象
string strCon = "Initial Catalog='***';Server='192.168.1.251,1433';User ID='sa';Password='server';Persist Security Info=True";
SqlConnection myConn = new SqlConnection(strCon);
sqlstr = "insert into AccountManual(MEMID,AMDate,AMNum,ForeTotalNum,TotalNum,ClassID,OperateDate,Operator) " +
"values('" + MEMID + "','" + AMDate + "'," + AMNum + "," + ForeTotalNum + "," + TotalNum + ",0,'" +
DateTime.Now + "','" + Convert.ToString(emp.EmployeeName) + "')";//select @@IDENTITY";
myConn.Open();
SqlCommand sqlCmd = new SqlCommand(sqlstr, myConn);
sqlCmd.ExecuteNonQuery();
myConn.Close(); //关闭连接
}
catch (Exception ex2)
{
}
AccountManual 表里面写有触发器,并且有很复杂的逻辑运算。
每当我操作该表的时候执行到 sqlCmd.ExecuteNonQuery(); 就会等待时间太久。
有没有什么方法只对连接执行 Transact-SQL 语句不返回受影响的行数。