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

Ôõô½øÈëMS ACCESSµÄSQLÓï¾ä²Ù×÷½çÃæ£¿

ÕÒ²»µ½MS accessÔÚÄÄÊäÈëSQLÓï¾ä´´½¨±íºÍ²Ù×÷±íÁË£¬ÄÄλ´ïÈ˰ïСµÜ˵һϲÙ×÷·½·¨°¡£¿
²éѯ£¬È»ºóÑ¡µÚÒ»Ïµ¯³öµÄ¶Ô»°¿òÑ¡¹Ø±Õ£¬µã´°ÌåµÄ×óÉϽÇSQL°´Å¥£¬µã̾ºÅÊÇÔËÐС£ÓÒ¼ü²Ëµ¥µÚ¶þÏî¿ÉÒÔ·µ»Øµ½sqlÓï¾äÊäÈë½çÃæ¡£

ÓÐÁ½´¦¿ÉÒÔÊäÈëSQLÓï¾ä£º 
  1¡¢ÔÚ²éѯÉè¼ÆÆ÷À·½·¨ÊÇн¨Ò»²éѯÔÚÉè¼ÆÆ÷ÖУ¬µ¥»÷×óÉϽǹ¤¾ßÀ¸µÄSQL£¬µ¯³öµÄ´°¿Ú¼´¿ÉÊäÈëSQLÓï¾ä¡£ 
  2¡¢ÔÚVBA³ÌÐòÖУ¬Ò²¿ÉÒÔÖ±½ÓÖ´ÐÐSQLÓïÑÔ£¬Òò´Ë¿ÉÔÚÆäÖÐÖ±½ÓÊäÈëÈçdocmd.runsql"ÄãµÄSQLÓï¾ä".

ѧϰÁË

ÓÃÕâ¸ö¿ÉÒÔÏñ²éѯ·ÖÎöÆ÷Ò»ÑùµÄģʽ²Ù×÷access
http://218.25.154.154:8081/Software/SqlEditPlugs.rar


Ïà¹ØÎÊ´ð£º

asp¸úAccessÊý¾ÝÁ¬½ÓÎÊÌâ¡£

IsSqlDataBase = 0 'Ö÷Êý¾Ý¿âÀàÐÍ(1=SQL£¬0=AC)

'===========================================================================
SqlDatabaseName = "ads365" 'Ö÷Êý¾Ý¿âÃû
S ......

SQLÓï¾äÎÊÌ⣬¸ßÊÖ°ïæ£¡£¡

½«Ò»¸ö±í21~30ɾ³ý£¬sqlÓï¾äÔõôд
Õâ¸öÌ«ÁýͳÁË£¬ÊÇÅÅÐòºóµÄµÚ21Ìõµ½30Ìõ¼Ç¼ɾ³ý»¹ÊÇijһÁÐÖµÔÚ21µ½30Ö®¼äµÄɾ³ý°¡£¿

21-30ÊÇʲôÒâ˼£¿×ֶεϰ¾Ídelete from table1 where col1>=21 and col1<=30
Ö¸µ ......

oracle sql developer ²éѯÏÔʾÖÐÎÄÂÒÂë

»·¾³£º1.win2003server+oracle9i
2.oracle9i×Ö·û¼¯ÎªAMERICAN_AMERICA.WE8ISO8859P1
3.oracle sql developer°æ±¾ 1.5.5
ÏÖÏóÃèÊö: 1.ÔÚsql developer ÖвéѯoracleÖеÄij¸ö±í£¬ÖÐÎÄÈ«²¿ÏÔʾΪÂÒÂë¡£ ......

C#ÈçºÎÅжÏÁ¬½Ósql serverÊý¾Ý¿â³É¹¦£¿

C#ÈçºÎÅжÏÁ¬½Ósql serverÊý¾Ý¿â³É¹¦£¿
try
{
connection.connect()
return true;
}
catch()
{
return false;
}

Â¥Ö÷ºÜ׿±£¬¿ªÁ˼¸ÌùÁË¡£

ÒýÓÃ
try
{
connection.connect( ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ