VBScript code: conn.execute("SET IDENTITY_INSERT [abc] On" & vbcrlf & "insert into [abc] (id,name,qq,msn) select (select top 1 id from [abc] order by id desc)+1,name,qq,msn) from [abc] where id="&sid&" & vbcrlf & "SET IDENTITY_Insert [abc] OFF")
ÕâÑù¿ÉÒÔ¸´ÖÆÐµÄÒ»ÐУ¬µ«ÊÇÈç¹ûÓкܶàÓû§Í¬Ê±Ê¹Óã¬Èç¹û²¢·¢µÄ»°£¬ÕâÀïÃæµÄselect top 1¿Ï¶¨¾Í²»¶ÔÁË£¿
СµÜÒªÓÃc# ×ö¸öС¹¤¾ß£¬¾ÍÊǸøÊý¾Ý¿âÖеıí¸ñÅúÁ¿²åÈëÊý¾Ý£¬ÎÒÏ뾡Á¿·ûºÏ±í½á¹¹¹ØÏµµÄÊý¾Ý²åÈë½üÀ´£¬ ±ÈÈçÒª¿¼ÂÇÖ÷Í⽡µÈÐÅÏ¢£¬±È·½Ëµ ÓÐ a b c dÈý¸ö±í£¬¶øÎÒÈçºÎÔÚÊý¾Ý¿âÖÐÈ·ÈÏÖ÷¼üºÍÍâ¼ü£¬µ½µ×¸ÃÈçºÎÈ·ÈϲåÈë˳Р......
ÈçÌâ,Ö»Òª±í½á¹¹.²»ÐèÒªÊý¾ÝµÄ.±í½á¹¹¸´Öƺܺø´ÖÆ.µ«ÊǸú±íÓйصĴ¥·¢Æ÷,Ë÷ÒýµÈ,»¹ÓÐͳ¼ÆÐÅÏ¢Õâ¸öÊý¾ÝÄܹ»Ò»Æð¸´ÖÆ×ßÂð.¾ÍÊÇÁ½ÕűíÊÇһģһÑùµÄ. select * into b from a