Microsoft SQL Server Management Studio 9.00.1399.00 Microsoft Analysis Services Client Tools 2005.090.1399.00 Microsoft Data Access Components (MDAC) 6.1.7600.16385 (win7_rtm.090713-1255) Microsoft MSXML 3.0 5.0 6.0 Microsoft Internet Explorer 8.0.7600.16385 Microsoft .NET Framework 2.0.50727.4927 Operating System 6.1.7600 ÎÒµÄÊÇ 5.0µÄºÃÏñ£¬Ã»ÈκÎÎÊÌâĿǰ DING! ¿ÉÒÔ£¬ÎÒ°²×°¹ý£¬²»¹ýÖ»ÊÇÉÔ΢ÓÃÁËÏ¡£ºóÀ´ÓÃsql serverÈ¥ÁË£¬µ«2008Óе㲻¼æÈÝ£¬Å¼¶û³öÏÖÀ¶ÆÁ¡£
Çë¸ßÊÖÖ¸µã,ÎÒ¶ÔÒ»Õűí²éѯºóÔÙ¸üÐÂ,²éѯÊÇ×Ó²éѯ,±¨´í: You can't specify target table 'a_table' for update in from clause ÍêÕûSQLÓï¾äÊÇ UPDATE a_table SET STATUS=0 WHERE ID=(SELECT MIN(ID) from a_tab ......
ÏÈÉÏ´íÎó ÎÞ·¨Áª½ÓÊý¾Ý¿â java.sql.SQLException: Before start of result set at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910) at com.mysql.jdbc.ResultSet.checkRowPos(ResultSet.java: ......