为何执行不了第二条语句?
代码如下;
<%
Sub   increate()
sql   =   "update   Mes_account   set   Account_total   =   "&   (original   +   tiaoshu)   &   ",Account_assign   =   "&(original   +   tiaoshu)& ",Account_mayuse   =   "&   (original_mayuse   +   tiaoshu   )   & "   where   Account_id= "   &   account_id
conn.execute(sql)

sql1=   "update   Mes_account   set   Account_assign   =   "&   (target_assign   +   tiaoshu)   &   ",Account_space   =   "&(target_space   -   tiaoshu)   &   ",Account_mayuse   =   "&   (target_mayuse   -   tiaoshu)   &   "   where   Account_id   =   "&   Session( "adminid ")
conn.execute(sql1)

Response.Write( " <script   language= 'javascript '> alert( '分配成功！ ');window.close();window.opener.location.href=window.opener.location.href; </script> ")

End   Sub
%>

进行浏览,测试后,执行,发现它并不执行第二条语句sql1,为什么呢?

打印出sql1是正常的.谢谢!

------解决方案--------------------
建议使用数据库的事务，然后看你的第二个T-SQL是否正确，可以先打印出来，然后在数据库客户端工具中去测试。