¡¡¡¡ÃÀ¹úÆøÏóѧ¼ÒÂåÂ××È£¨E.N.Lorenz£¬²»ÒªºÍÌá³öÂåÂ××ȱ任µÄÄÇλ¸ã»ì£©ÊÇ»ìãçÀíÂ۵ĵì»ùÕßÖ®Ò»¡£20ÊÀ¼Í50Äê´úÄ©µ½60Äê´ú³õ£¬ËûµÄÖ÷Òª¹¤×÷Ä¿±êÊÇ´ÓÀíÂÛÉ϶ÔÌìÆøÇé¿ö½øÐг¤ÆÚÔ¤±¨¡£ÔÚʹÓüÆËã»úÄ£ÄâÌìÆøÊ±£¬ËûÒâÍâµØ·¢ÏÖ£¬¶ÔÓÚÌìÆøÏµÍ³£¬ÄÄųõʼÌõ¼þµÄ΢С¸Ä±äÒ²»áÏÔÖøÓ°ÏìÔËËã½á¹û¡£Ëæºó£¬ËûÔÚͬʹ¤×÷µÄ»ù´¡ÉÏ»¯¼òÁË×Ô¼º ......
ÎÒÏëɾ³ýÊý¾Ý¡¡¡¡¿ÉÀÏÌáʾ´íÎó¡«¡«
´ó¼ÒÀ´¿´¿´Ôõô»ØÊÂ
ɾ³ýÒ²Ãæ´úÂ룺
<!--#include file="bconn.asp"-->
<%
dim id,sql
id=request.QueryString("id")'»ñÈ¡Á¬½ÓÖеÄIDºÅ
sql="delete from lyl where id ="&id 'Ö¸¶¨É¾³ýµÄID£¬²»È»±íÀïµÄ¶«Î÷¶ ......
×î½øÔÚʹÓÃaccessµÄʱºò·¢ÏÖÁËÏÂÃæµÄÒ»¸öÎÊÌâ sqlÓï¾äÈçÏ£ºselect a.* ,b.* from a inner join b on a.a = b.a where 1 = 0 ÔÚaccessÀï²éѯÕâ¸öÓï¾ä»á·¢ÏÖÓÐÒ»Ìõ¿Õ¼Ç¼,
µ«µ±ÎÒ»»³ÉÏÂÃæµÄÓï¾ä¾ÍûÓпռǼÁË select a.* ,b.* from a ,b where a.a = b.a and 1 = 0
´ó¼ÒÄܸæËßÎÒÊÇʲôÔÒò? ÁíÍâ×óÍâÁ¬½ÓµÄ·ûº ......
ÎÒ»ú×ÓÀïÃæÃ»ÓÐACCESS,ÇëÎÊÔÚ²»ÖØ×°ÏµÍ³µÄÇé¿öϸÃÈçºÎ°ÑËü×°ÉÏ,֮ǰÎÒÊÔ×°¹ýÆäËü°æ±¾µÄSP3 OFFICE,µ«»¹ÊÇ×°²»ÉÏ,
ÇëÎÊÓÐʲôºÃ°ì·¨Âð?
°²×°OFFICE £¬Ñ¡Ôñ°²×°ACCESS¾Í¿ÉÒÔѽ ¡£
ÒýÓÃ
°²×°OFFICE £¬Ñ¡Ôñ°²×°ACCESS¾Í¿ÉÒÔѽ ¡£
ʵÔÚ²»»áµÄ»°£¬µçÄÔ³ÇÂòÕÅ5¿éÇ®µÄOFFICEµú£¬Ñ¡ÔñÈ«²¿°²×°£¬¾Í¿ÉÒÔÁË£¬
Òª²»¾ÍÈ¥¿´Î¢Èí ......
ÓÐ2¸ö±í TB1 ºÍTB2
TB1ÖÐÓÐÒ»¸ö×Ö¶Îcount
TB2ÖÐÓÐÈý¸ö×Ö¶Înum1,num2,num3
ÏÖÔÚÎÒÒª¸ù¾ÝcountµÄÖµÀ´ÅжÏÊÇÔÚ±íTB2Öеĵڼ¸Ï¼´countÔÚnum1[i]ºÍnum2[i]Ö®¼ä£¬(iÊDZíTB2µÄ×ܹ²Óм¸Ìõ£©Èç¹ûÔÚµÚÒ»ÏîÖ®¼ä¾Í¶Á³önum3[0],
Èç¹ûÔÚTB2µÄµÚÈýÏîÖ®¼ä£¬ÄÇô¾Í¶Á³ösum3[2],
ÇëÎʸÃÔõôдSQLÓï¾ä°¡£¿
° ......
UPDATE djdata AS a, d071_10_mj AS b SET a.d071 = b.d071_1 WHERE a.qsdwdm=b.zldwdm and a.qsxz='10';
ÔËÐÐʱÌáʾ[²Ù×÷±ØÐëÒ»¸ö¿É¸üеIJéѯ]ÊÇʲôÒâ˼?
µ±ÄúµÄÎÊÌâµÃµ½½â´ðºóÇ뼰ʱ½áÌù.
http://topic.csdn.net/u/20090501/15/7548d251-aec2-4975-a9bf-ca09a5551ba5.html
ѧϰ
......