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¿Ï¶¨¾Í²»¶ÔÁË£¿
ÈçÌâ,Ö»Òª±í½á¹¹.²»ÐèÒªÊý¾ÝµÄ.±í½á¹¹¸´Öƺܺø´ÖÆ.µ«ÊǸú±íÓйصĴ¥·¢Æ÷,Ë÷ÒýµÈ,»¹ÓÐͳ¼ÆÐÅÏ¢Õâ¸öÊý¾ÝÄܹ»Ò»Æð¸´ÖÆ×ßÂð.¾ÍÊÇÁ½ÕűíÊÇһģһÑùµÄ. select * into b from a
UPDATE a SET a.KeyNum=(SELECT COUNT(b.CI_ID) from myTab.dbo.CI_SinKey as b where CONTAINS(b.SearchKey,a.KeyName) ) from myKey.dbo.SearchKey as a where KeyNum=0 Õâ¸öÊÇ´íÎóµÄÓï¾ä£¬ÏàÐÅ´ó¼Ò¿ÉÒÔ¿´¶® ......