Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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Êý¾Ý¿â °¡£¿
  ¸øÐ¡µÜÒ»¸ö£¡
°²×°OFFICEʱѡÔñ°²×°ACCESS

°²×°OFFICEʱѡÔñ°²×°ACCESS

°²×°°ì¹«Èí¼þ£¬Ñ¡Ôñ×Ô¶¨Òå°²×°£¬È»ºóÑ¡ÉÏACCESS¾Í¿ÉÒÔÁË

officeÍêÕ ......

ʹÓÃRepeater¶ÁÈ¡access±í£¬Ò³Ãæ´ò¿ª·Ç³£Âý

accessÊý¾Ý¿â£¬Ö±½ÓʹÓà select ×Ö¶Î from ±í  ¶ÁÈ¡Êý¾Ý
È»ºóÔÚÒ³ÃæÖÐʹÓÃRepeaterÀ´ÏÔʾ
ÕâÕűíÓÐ2000ÌõÊý¾Ý£¬ËùÒÔÒ³Ãæ´ò¿ªµÄºÜÂý
Çë½Ì¸÷λÅóÓÑ£¬ÓÐûÓа취½â¾ö£¬Ìá¸ßµãËÙ¶È£¡
Ò»´ÎÈ«²¿¶ÁÍê ......

ÈçºÎ½«ExcelÊý¾Ýµ¼ÈëAccessÊý¾Ý¿â? ¸øÒ»¶Î´úÂë

ÈçºÎ½«ExcelÊý¾Ýµ¼ÈëAccessÊý¾Ý¿â?,
±íÃû:crk

²»¶¥²»ÐÐ

excel¿ÉÒÔÖ±½Ó×÷ΪÊý¾Ý¿â²Ù×÷
ʹÓÃADOÈ»ºó¸ã½øÈ¥


procedure TExInput.Excel1Click(Sender: TObject); //ʵÏÖExcelµ¼ÈëSQL
var
& ......

MFCÁ¬½ÓACCESS ³ö´í

Âé·³¸÷λ°ïæ¿´¿´°¡
´úÂëÈçÏ£º
CoInitialize(NULL);
  _ConnectionPtr pConn(__uuidof(Connection)); 
_RecordsetPtr pRst(__uuidof(Recordset));
pConn->ConnectionString="Provider ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ