¹úÇì½ÚÒ»ÎÊ: ÈçºÎÅúÁ¿¸üÐÂAccessÖÐ×ֶβ¿·ÖÄÚÈÝ?
ÎÒÏÖÔÚaccess±íÖÐijһ×Ö¶ÎA ÓÐÏÂÃæµÄÄÚÈÝ(Ö»ÊǺóÃæµÄ²¿·Ö²»Ïàͬ)
1.http://www.google.cn/search?client=pub-475201884&forid=1&prog=aff&ie=GB2312&oe=GB2312&hl=zh-CN&q=ËûºÍËýµÄÄÐÈË
2.http://www.google.cn/search?client=pub-475201884&forid=1&prog=aff&ie=GB2312&oe=GB2312&hl=zh-CN&q=¼ÓÀձȺ£µÁ3
3.http://www.google.cn/search?client=pub-475201884&forid=1&prog=aff&ie=GB2312&oe=GB2312&hl=zh-CN&q=̨¾ç-18½û²»½û
ÎÒÖ»ÏëÐÞ¸ÄÆäÖеÄpub-475201884ΪÆäËûµÄÄÚÈÝ
ÇëÎÊÓÃÒ»ÌõsqlÓï¾äÊÇ·ñÄÜÍê³É!!
²»ÖªµÀACCESSÓÐûÓÐÕâ¸öº¯ÊýÄØ
UPDATE TB SET COL=REPLACE(COL,'pub-475201884','FDSFD')
ʹÓÃREPLACEº¯Êý
update tb from a = replace(a,'pub-475201884','xxx')
accessÖÐûÓÐÕâ¸öº¯Êý
½¨ÒéÔÚǰ̨´¦Àí
asp,asp.netÖж¼Óк¯Êý´¦Àí
ÍøÉÏÓкܶàAccess×Ö·ûÌæ»»¹¤¾ß
ÊÔÁËһϠaccess 2003 Ö§³Ö replace º¯Êý
Ïà¹ØÎÊ´ð£º
ÎÒµÄÊý¾Ý¿âÊǼòÌåsqlserver2000 ,ÎÒÏëÔÚ·±ÌåaccessÏÂÁ¬½Ó,ͨ¹ýodbcÊÇ¿ÉÒÔÁË,µ«ÔÚaccessϳöÏÖ´ò¿ªµÄ±íÈ«ÖÐ"#ÒÑɾ³ý"
²»ÖªµÀÒªÔõô²Ù×÷²Å¿ÉÒÔÓÃACCESS·±ÌåÁ¬½Ó¼òÌåsqlserver2000.лл!!!
´ó¼Ò¶¼ ......
ÔÚaccessÖÐÔõôִÐÐselect TOP (@size) * from table1
Õâ¸öTOPÔõô´ø²ÎÊý²éѯ°¡
ÓÃVBA¶¯Ì¬Éú³ÉSQLÓï¾ä£¬ÔÙÖ´ÐÐ
²»ÄÜÖ±½ÓÓÃSQLÓï¾ä£¬ÓÃ×Ö·û´®ÀÛ¼ÓÉú³ÉSQLÓï¾äµÄ·½·¨À´Ö´ÐÐSQLÓï¾ä
top n Õâ¸öûÓа취ʹÓò ......
¸øaccessÊý¾Ý¿â¼ÓÃܵIJ½ÖèÈçÏ£º
£¨1£©´ò¿ªaccessÈí¼þ£¬½çÃæÈçͼ1Ëùʾ
......
sqlÓï¾ä£º
SELECT top 12 Forum.ID,Forum.topic,Reforum.id,Reforum.username,Reforum.posttime,Reforum.postip,Forum.username from Forum INNER JOIN Reforum ON Forum.ID = Reforum.topicid wher ......
//**********************************
//³ÌÐò¹¦ÄÜ£º´´½¨AccessÊý¾Ý¿âºÍÊý¾Ý±í
//**********************************
unit Unit1;
interface
uses
Windows, Messages, SysUtils, ......