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¿Ï¶¨¾Í²»¶ÔÁË£¿
¹òÇó½«ÒÔϺ¯Êý·ÒëΪ mysql µÄÓï·¨ CREATE FUNCTION workdayadd( @date datetime, --»ù´¡ÈÕÆÚ @workday int --ÒªÔö¼ÓµÄ¹¤×÷ÈÕÊý )RETURNS datetime AS BEGIN DEC ......