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¿Ï¶¨¾Í²»¶ÔÁË£¿
Warning: odbc_connect() [function.odbc-connect]: SQL error: [Microsoft][ODBC Çý¶¯³ÌÐò¹ÜÀíÆ÷] δ·¢ÏÖÊý¾ÝÔ´Ãû³Æ²¢ÇÒδָ¶¨Ä¬ÈÏÇý¶¯³ÌÐò, SQL state IM002 in SQLConnect in D:\0\msc\msc\tel.php on line 44 Í ......
ÅжϱíÖÐÊÇ·ñÓдóÓÚ10ÌõÒÔÉϵÄÊý¾Ý£¬ Èç¹û´æÔÚÔò°´×îºÃ¼ÈëµÄʱ¼ä£¬É¾³ýµô¶àÓàµÄÊý¾Ý¡£¡£ ±£³ÖÊý¾Ý±íÖÐÖ»ÓÐ10Ìõ×îеÄÊý¾Ý¡£¡£ лл¡£ select ID,count(1) from TB group by ID having count(1)>10
¹òÇó½«ÒÔϺ¯Êý·ÒëΪ mysql µÄÓï·¨ CREATE FUNCTION workdayadd( @date datetime, --»ù´¡ÈÕÆÚ @workday int --ÒªÔö¼ÓµÄ¹¤×÷ÈÕÊý )RETURNS datetime AS BEGIN DEC ......