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

ÓôÃÆ£¬ACCESSÖС¡select top 1 ²éµ½µÄÊý¾ÝΪ2Ìõ

ACCESS ÖС¡select top 1 ²éµ½µÄÊý¾ÝΪ2Ìõ£¬Ôõô»ØÊÂ
ÉñÆæ

±È½ÏÆæ¹Ö

Ï൱µÄÉñÆæ£¡


0

ÒýÓÃ
--²éÁËÒ»ÏÂ×ÊÁÏ
jet sql »á·µ»ØÖظ´Öµ£¬Ò²¾ÍÊÇ˵£¬Ò»¸ö±íÖÐÈç¹û ORDER BY µÄ×ֶζ¼ÊÇ 0 £¬Ò»¹²ÓÐ100Ìõ¼Ç¼£¬¼´Ê¹ÄãÓÃSELECT TOP 1 À´·µ»Ø¼Ç¼£¬Ò²Í¬Ñù·µ»Ø100Ìõ¼Ç¼£¬ÒòΪ JET DB ÎÞ´ÓÔÚÕâ100Ìõ¼Ç¼ÀïÃæÅжÏÏȺó´ÎÐò£¬Ö»ÄÜ·µ»Ø100Ìõ¡£Òª½â¾ö´ËÎÊÌâ¿ÉÒÔ½¨Á¢Ò»¸ö×Ô¶¯±àºÅ×Ö¶Î(id)£¬È»ºóÓÃ
SELECT TOP 1 a,id from tablename order by a,id




Å££¬Ì«Å£ÁË£¡

ѧϰÁË£¬Ð»Ð»ÁË

ѧϰÁË£¬Ð»Ð»ÁË

ѧϰÁË£¬Ð»Ð»ÁË

ÕâÑù½á¹û¾Í¶ÔÁË£¬selectÖмÓÁËid£¬ÍüÁËÔÚorder by ÖмÓÉÏid


Ïà¹ØÎÊ´ð£º

Access²éÕÒÖØ¸´ÎÊÌâ

ACCESSÊý¾Ý¿âÖÐÓÐÒ»¸ötablename±í£¬Éè¼ÆÈçÏ 
±àºÅ,ÊéÃû,×÷Õß,³ö°æÊ±¼ä,³ö°æÉç,ISBN,Ŀ¼,¼ò½é
ÆäÖгý¡°±àºÅ¡±Îª×Ô¶¯±àºÅÍ⣬ÆäËü¶¼Îª¡°±¸×¢¡± 
ÆäÖÐ"±àºÅ"άһ£¬ÔÚ¡°ISBN¡±ÖÐÓеÄΪ¿ÕÖµ£¬ ......

ASP+ACCESSÊä³öÎÊÌâ - Web ¿ª·¢ / ASP

ÄÄÀï³ö´íÁË£¬Êä³öÕâÑùµÄ½á¹û£¿£¿
<%@ Page Language="VB" AutoEventWireup="false" aspcompat="true" CodeFile="Default.aspx.vb" Inherits="_Default" %&g ......

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

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

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

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


(ÔÚA ......

¹ØÓÚaccessÊý¾Ý¿âÁ¬½Ó¾ø¶Ô·¾¶µÄÎÊÌâÇó½â

Êý¾Ý¿âÁ¬½ÓÌáʾÈçϱ¨´í£¬¿´µÄ³öÀ´ÊÇÒ³ÃæÓëÊý¾Ý¿âÁ¬½ÓµÄÎÊÌ⣬ÏÖÔÚÎÒµÄÊÇÏà¶ÔÁ¬½Ó¡£
ÒªÔõô½«Æä¸Ã³É¾ø¶ÔÁ¬½ÓÄØ£¿ÎÒµÄÊý¾Ý¿âÎļþ·¾¶ÔÚ£º
D:\web\db
»¹ÊÇÒªÏÈлл´óÈËÃǰïÖúС°×²ËÎÒ


Microsoft O ......

_access ÇëÎÊÕâ¸öº¯ÊýÊǸÉÂïÓõģ¿

ËüµÄ¶¨ÒåÊÇÕâÑùµÄ


_CRTIMP __checkReturn int __cdecl _access(__in_z const char * _Filename, __in int _AccessMode);



´ó¸ç£¬¿´¸öº¯ÊýÉùÃ÷¾ÍÄÜ¿´³öËû¸ÉɶµÄ£¿

´ÓÃüÃûÀ´¿´Ó¦¸ÃÊÇÅж ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ