ÔÚaccessÖÐÔõôʵÏÖÀàËÆsqlÖеĴ¥·¢Æ÷Ò»ÑùµÄ¹¦ÄÜ£¿
ÔÚsqlÖпÉÒÔͨ¹ý´¥·¢Æ÷£¬ÊµÏÖ´Ó±íÖеÄÊý¾Ý¸Ä±äʱͬʱ¸üÐÂÖ÷±íÖеÄÊý¾Ý¡£
ÔÚaccessÖÐÔõôʵÏÖÀàËÆsqlÖеĴ¥·¢Æ÷Ò»ÑùµÄ¹¦ÄÜ£¿
ACCESS Öв»Ö§³Ö´¥·¢Æ÷ºÍ´æ´¢¹ý³Ì¡£
Èç¹ûÄãÔÚ£Á£Ã£Ã£Å£Ó£ÓÄÚ²¿Ê¹Ó㬿ÉÒÔͨ¹ý£Ö£Â£ÁºÍ£Æ£Ï£Ò£ÍÖеĴúÂëÀ´ÊµÏÖÀàËÆ¹¦ÄÜ¡£
Èç¹ûÄãÔÚÆäËü³ÌÐòÖÐͨ¹ý£Á£Ä£Ï£¯£Ï£Ä£Â£ÃÀ´·ÃÎÊ£Á£Ã£Ã£Å£Ó£ÓµÄÊý¾Ý¿â£¬ÔòûÓа취£¬Ö»ÄÜÔÚÄã×Ô¼ºµÄ³ÌÐòÖÐÀ´ÊµÏÖÁË¡£
ACCESSûÓд¥·¢Æ÷£¬Ö»ÓÐÓôúÂë½â¾ö
Äܲ»ÄÜ˵Ïêϸµã¶ù£¿
ͬʱ¾Ù¸öÀý×Ó
Çë²Î¿¼ÒÔÏÂÎÄÕ¼°ÆäÏà¹ØÎÄÕ£º
ACCESS±íÊÇ·ñÖ§³Ö´¥·¢Æ÷£¿
http://www.access911.net/?kbid;72FAB21E11DCE7F3
Ä㻹ÓÐÒ»Ìõ·¿ÉÒÔ×ߣ¬»»Óà OFFICE ACCESS 2010
¹ØÓÚ´ËÖ÷ÌâÇë²Î¿¼£º
Access 2010й¦ÄܽéÉÜ£ºTableEvents
http://www.access911.net/index.asp?u1=a&u2=72FABF1E12DCE6F3
лл¸÷λµÄ»Ø´ð£¬ÎÒ×Ô¼ºÊµ¼ùÒ»ÏÂ
ÓÐÎÊÌâÎÒÔÙÎÊÄãÃÇÁË
Ïà¹ØÎÊ´ð£º
sql¿ÉÒÔÓÐÁ½¸öÒÔÉϵĴ¥·¢Æ÷Â𣿣¿ÎÒÖ¸µÄÊÇfor´¥·¢Æ÷£¬ÄÇÆäËûµÄÄØ£¿£¿
ʲôÒâ˼£¿
¿ÉÒÔµÄ
10¸ö¶¼Ã»ÎÊÌâ
¿ÉÊÇÎÒдÁËÁ½¸öfor insert ´¥·¢Æ÷£¬Ôì³É½ø³Ì×èÈûÁËÄØ£¿Ôõô°ìÄØ£¿Çë¸ßÈËÖ¸µã
......
ÎÒÓжà¸ö±íA B C ½á¹¹ÊÇÒ»ÑùµÄ£¬¶¼ÓÐ2¸ö×Ö¶ÎnameºÍcontent,ÎÒÒªËÑË÷ËùÒÔ±íËùÓÐ×Ö¶ÎÖаüº¬¡°Öйú¡±µÄÄÚÈÝ Õâ¸öSQLÓï¾äÔõôд
ÈçºÎ½«¶à¸ö±íµÄ²éѯ½á¹ûÁ¬³ÉÒ»¸ö±í Õâ¸öSQLÓï¾äÔõôд ±íµÄ½á¹¹ÊÇÒ»ÑùµÄ
ÀýÈç£ ......
±íÈçÏÂ
½ÌÊÒID ×ùλÊý ¿ªÊ¼Ê±¼ä ½áÊøÊ±¼ä 2009Äê1ÔÂ1ÈÕ 2009Äê1ÔÂ2ÈÕ 2009Äê1ÔÂ3ÈÕ
101 50 08£º00 08£º30 30 40 50
101 50 09£º00 ......
ÏÖÔÚÓÐÒ»ORACLEÖеÄSQLÓï¾ä£¬ÐèÒªÒÆÖ²µ½DB2ÖУ¬ÇëÎʸÃSQL¸ÄÈçºÎд
ORACLEÖУº
select floor(months_between(date1,date2)) from A
date1,date2·Ö±ðΪ±íÖеÄÁ½¸ö×Ö¶Î £¬¶¼ÎªÈÕÆÚÐÍ
DB2ÖÐÈçºÎʹÓÃÐ ......
Çë¸÷λָµãÏ£º³ÌÐò´úÂëÈçÏÂmingchen = "C:\Îļþ·¾¶\"
cat = New ADOX.Catalog
cat.Create("Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=" & min ......