¹ØÓÚaccess±íÖÐÊý¾Ýµ¼Èë - ÆäËûÊý¾Ý¿â¿ª·¢ / Access
ÈçºÎͨ¹ýsqlÓï¾ä ½«Ò»¸öaccessÊý¾Ý¿â ij±íÖеÄijЩÊý¾Ý µ¼Èëµ½ÁíÒ»ÕűíÖÐ
ÎÒϵͳ µÄÒ»ÅúÊý¾Ý¶ªÊ§ÁË ÐèÒªÔÚÁíÒ»¸öÊý¾Ý¿âÖе¼Èë
¼±¼±¼±¼±¼±
ÈçºÎͨ¹ýsqlÓï¾ä ½«Ò»¸öaccessÊý¾Ý¿â ij±íÖеÄijЩÊý¾Ý µ¼Èëµ½ÁíÒ»¸öaccessÊý¾Ý¿â ÁíÒ»ÕűíÖÐ
ÄÇÈçºÎÔÚadoÖÐÖ´ÐÐÄØ?
Ïà¹ØÎÊ´ð£º
vcÖÐÓÃodbcµÄ·½·¨·ÃÎÊaccessÊý¾Ý¿â£¬Óõ½ÁËcdatabaseÀàºÍcrecordsetÀà¡£Êý¾ÝÔ´ÔÚ´°¿Ú³õʼ»¯µÄʱºò±»´ò¿ªg_datasource.Open("data",FALSE,FALSE); µã»÷Ò»¸ö°´Å¥Æô¶¯Ò»¸ö¶¨Ê±Æ÷£¬ÔÚ¶¨Ê±Æ÷ÄÚÍê³ÉÒÔϲÙ×÷£¬¶¨ ......
ÇëÎÊÓÐÈËÖªµÀÈçºÎÔÚkernel mode ÏÂд64 bit driver, ¿ÉÒÔ½«IO bitmap ´ò¿ª£¬
32bit¿ÉÒÔÓÃKe386SetIoAccessMapºÍKe386IoSetAccessProcess£¬
Çë問64 bit driverÓÐÀàËÆµÄfunctionaÂð?
ûŪ¹ý¡£
GoogleµÄ£ºhtt ......
ÎÒÏë±£Áô±íÖÐ×îеÄ30¸öÊý¾Ý£¨ÓмǼʱ¼äµÄ×Ö¶Îaddtime£©£¬ÆäÓàµÄɾ³ý£¬ÇëÎÊsqlÓï¾äÔõÑùÐ´ÄØ£¿Ð»Ð»¡£
End_rbody_64466527//-->
¸Ã»Ø¸´ÓÚ2010-04-27 08:37:30±»°æÖ÷ɾ³ý
¶ÔÎÒÓÐÓÃ[0]
¶ª¸ö°åש[ ......
oracle ´úÂ룺
select * from (select * row_number() over ( partition by ÁªÏµºÅÂë order by ÒµÎñºÅÂë ) rn from ºÅÂë²éѯ) where rn<2
Ч¹ûÊÇ£º½« ijһָ¶¨×ֶΠɾ³ýÖØ¸´µÄºÅÂ룬²¢±£Áô¸ÃºÅÂëÏà¹ØµÄÆäËûÐ ......
ÈçºÎÓÃSQL½«Access±íÖеÄÊý¾ÝÈ¥²»Çå¿Õ£¿
ÈçºÎÓÃsql½«ACCESS²¿·ÖÊý¾Ý±íÖеĵÄÊý¾ÝÇå¿Õ£¿
ÈçºÎÓÃSQL½«Access±íÖеÄÊý¾ÝÈ¥²»Çå¿Õ£¿
¾ÙÀý˵Ã÷
ÈçºÎÓÃsql½«ACCESS²¿·ÖÊý¾Ý±íÖеĵÄÊý¾ÝÇå¿Õ£¿
delete from tt
ÓÃSQ ......