Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ÔÚ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¿ÉÒÔÓÐÁ½¸öÒÔÉϵĴ¥·¢Æ÷Â𣿣¿

sql¿ÉÒÔÓÐÁ½¸öÒÔÉϵĴ¥·¢Æ÷Â𣿣¿ÎÒÖ¸µÄÊÇfor´¥·¢Æ÷£¬ÄÇÆäËûµÄÄØ£¿£¿
ʲôÒâ˼£¿

¿ÉÒÔµÄ

10¸ö¶¼Ã»ÎÊÌâ

¿ÉÊÇÎÒдÁËÁ½¸öfor insert ´¥·¢Æ÷£¬Ôì³É½ø³Ì×èÈûÁËÄØ£¿Ôõô°ìÄØ£¿Çë¸ßÈËÖ¸µã
......

sqlÓï¾ä¶à±í¶à×ֶβéѯ - MS-SQL Server / »ù´¡Àà

ÎÒÓжà¸ö±íA B C ½á¹¹ÊÇÒ»ÑùµÄ£¬¶¼ÓÐ2¸ö×Ö¶ÎnameºÍcontent,ÎÒÒªËÑË÷ËùÒÔ±íËùÓÐ×Ö¶ÎÖаüº¬¡°Öйú¡±µÄÄÚÈÝ Õâ¸öSQLÓï¾äÔõôд 

ÈçºÎ½«¶à¸ö±íµÄ²éѯ½á¹ûÁ¬³ÉÒ»¸ö±í Õâ¸öSQLÓï¾äÔõôд ±íµÄ½á¹¹ÊÇÒ»ÑùµÄ
ÀýÈç£ ......

ÇóÒ»SQL - MS-SQL Server / »ù´¡Àà

±íÈçÏÂ
½ÌÊÒID ×ùλÊý ¿ªÊ¼Ê±¼ä ½áÊøÊ±¼ä 2009Äê1ÔÂ1ÈÕ 2009Äê1ÔÂ2ÈÕ 2009Äê1ÔÂ3ÈÕ
  101 50 08£º00 08£º30 30 40 50  
  101 50 09£º00 ......

´ÓORACLEµ½DB2µÄSQLÓï¾äÎÊÌâ

ÏÖÔÚÓÐÒ»ORACLEÖеÄSQLÓï¾ä£¬ÐèÒªÒÆÖ²µ½DB2ÖУ¬ÇëÎʸÃSQL¸ÄÈçºÎд
ORACLEÖУº
select floor(months_between(date1,date2)) from A  
date1,date2·Ö±ðΪ±íÖеÄÁ½¸ö×Ö¶Î £¬¶¼ÎªÈÕÆÚÐÍ 
DB2ÖÐÈçºÎʹÓÃÐ ......

vb.net ´´½¨accessÊý¾Ý±íʵÏÖÒ»Êý¾Ý¿â¶à¸öÊý¾Ý±í£¿

Çë¸÷λָµãÏ£º³ÌÐò´úÂëÈçÏÂmingchen = "C:\Îļþ·¾¶\"
cat = New ADOX.Catalog
cat.Create("Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=" & min ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ