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

Êý¾Ý¿âÊÇAccessµÄ£¬¿ÉÒÔÓô洢¹ý³ÌÂð

Êý¾Ý¿âÊÇAccessµÄ£¬¿ÉÒÔÓô洢¹ý³ÌÂð ?

ÔõôÓÃà¸?

ACCESSûÓд洢¹ý³ÌµÄ.Ö»ÓÐQUERY

»òÕßдºê»òÕßVBAÄ£¿é°É

תµ½SQLÖÐÈ¥ÓÃ

ûÓÐ

ÒýÓÃ
ACCESSûÓд洢¹ý³ÌµÄ.Ö»ÓÐQUERY



QUERY¿ÉÒÔ´úÌæ´æ´¢¹ý³ÌÂð

ÒýÓÃ
ÒýÓà 1 Â¥ icelovey µÄ»Ø¸´:
ACCESSûÓд洢¹ý³ÌµÄ.Ö»ÓÐQUERY


QUERY¿ÉÒÔ´úÌæ´æ´¢¹ý³ÌÂð

µ±È»Ã»Óд洢¹ý³ÌÇ¿´ó, Ò»¸öQUERYÖ»ÊÇÖ´ÐÐÒ»²½¸üлòÕßɾ³ý²åÈëµÄ¶¯×÷¶øÒÑ
¶ø´æ´¢¹ý³ÌÀïÃæ¿ÉÒÔдºÜ¶àµÄ¶¯×÷..
ͨË×µã¾ÍÊÇÒ»¸ö´æ´¢¹ý³ÌµÈÓںܶà¸öQUERYµÄ¼¯ºÏ

ÒýÓÃ
ÒýÓà 5 Â¥ jiejie526 µÄ»Ø¸´:
ÒýÓà 1 Â¥ icelovey µÄ»Ø¸´:
ACCESSûÓд洢¹ý³ÌµÄ.Ö»ÓÐQUERY


QUERY¿ÉÒÔ´úÌæ´æ´¢¹ý³ÌÂð

µ±È»Ã»Óд洢¹ý³ÌÇ¿´ó, Ò»¸öQUERYÖ»ÊÇÖ´ÐÐÒ»²½¸üлòÕßɾ³ý²åÈëµÄ¶¯×÷¶øÒÑ
¶ø´æ´¢¹ý³ÌÀïÃæ¿ÉÒÔдºÜ¶àµÄ¶¯×÷..
ͨË×µã¾ÍÊÇÒ»¸ö´æ´¢¹ý³ÌµÈÓںܶà¸öQUERYµÄ¼¯ºÏ


ÕâЩÄÜÓÃÔÚQueryÀïÂ𣿣¿

C# code:

--參¿¼ 轉
declare @str varchar(100)
set @str='SA' --ÒªËÑË÷µÄ×Ö·û´®

declare @s varchar(8000)
declare tb cursor local for
select s='if exists(select 1 from ['+b.name+'] where ['+a.name+'] like ''%'+@str+'%'')
print ''ËùÔÚµÄ±í¼°×Ö¶Î: ['+b.nam


Ïà¹ØÎÊ´ð£º

access ÖÐÖ´ÐÐsqlÓï¾äupdate²»³É¹¦£¬ÇóÖú£¡£¡£¡

access ÖÐÖ´ÐÐsql updateÓï¾äʱÓÐʱºò³É¹¦ÓÐʱºò²»³É¹¦£¬µ«ÊÇaccessÖв»³ö´íÎóÐÅÏ¢£¬²»ÖªµÀÊÇʲôԭÒò£¬ÓÐÄÄλ´óÏÀÖªµÀ£¬Çë°ïæ°¡
ÌùSQLÓï¾ä£¬¼ì²é±í¡¢×ֶεÄÓÐЧÐÔÉèÖÃ

sql ÔÚ²éѯ·ÖÎöÆ÷ÀïÃæ Ö´ÐкÜÕý³£

ÊÇ ......

ACCESSµÄ×Ô¶¨Ò庯ÊýÔÚdelphiÀïÔõôÓÃÄØ...

ÎÒÔÚÄ£¿éÀï×Ô¶¨ÒåÁËÒ»¸öº¯Êý:stradd()

¿ÉÊÇÔÚadoquery1.sql.add('select stradd(author) from book');
ʱÌáʾstradd䶨Òå...

Õâ¸öÎÊÌâÓÐʲô°ì·¨¿ÉÒÔ½â¾öµÄÂð? ·Ç³£¸Ð¼¤!


(ÔÚA ......

¹ØÓÚDelphiÁ¬½ÓACCESSÊý¾Ý¿â²éѯÎÊÌâ

¸÷λ´óϺ£¬Ð¡µÜÓõÄÊÇADOÁ¬½ÓACCESSÊý¾Ý¿â£¬ÓÃDBGridÏÔʾ²éѯµÄÊý¾Ý£¬ÎÒ×öµÄÊǸöÊý¾Ý²É¼¯ÏµÍ³£¬¸ù¾Ý²»Í¬µÄµØÖ·°ÑÊý¾Ý·ÅÔÚACCESSÊý¾Ý¿âÖв»Í¬µÄ±íÀïÃæ£¬ÏÖÔÚÎÒÏë²éѯijһ¶Îʱ¼äÄÚËùÓбíÄÚµÄÊý¾Ý£¬²¢ÇÒÔÚDBGridÖÐÏÔʾ³ ......

MFCÁ¬½ÓACCESS ³ö´í

Âé·³¸÷λ°ïæ¿´¿´°¡
´úÂëÈçÏ£º
CoInitialize(NULL);
  _ConnectionPtr pConn(__uuidof(Connection)); 
_RecordsetPtr pRst(__uuidof(Recordset));
pConn->ConnectionString="Provider ......

ÈçºÎÉ趨access logÖеÄauthenticated username?

ÔÚ°¢ÅÁÆæµÄweb access logÖУ¬ÓÐÒ»¸öÊÇÓû§ÃûÑ¡ÏĬÈÏÊÇÓòÓû§Ãû¡£Èç¹ûÎÒÓõÄÊÇform ·½Ê½µÇ½£¬Ïë°ÑÕâ¸öÓû§Ãûдµ½access logÖÐÔõôʵÏÖ£¿

Â¥Éϵģ¬ ÏÖÔÚµÄaccess log ÊÇÕâÑùµÄ
2009-07-04 02:16:37 110.110 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ