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

ACCESSÊý¾Ý¿âµ½SQLÊý¾Ý¿â

 ´ÓAccessÊý¾Ý¿âµ¼Èëµ½SQL
·½·¨Ò»:
ÔÚMSsqlÖÐÒª¼òÀúODBC..·½·¨±È½Ï±¿µã..
·½·¨¶þ:
Ö±½Ó´ÓAccessÉýǨµ½MSsql..
ÒòΪAccessÊý¾Ý¿âÓÐÉèÖÃÃÜÂë..»¹Õæ²»ºÃ¸ã..¸ãÁ˺ü¸´Î¶¼Ê§°ÜÁË..
ÀûÓ÷½·¨¶þ..Ò»´Î³É¹¦..
ÓÃÊý¾Ý¿âÉýǨ...¼òµ¥...
½¨ÒéʹÓõڶþÖÖ·½·¨µ¼ÈëACCESSÊý¾Ý¿âµ½MSSQLÊý¾Ý¿âÖÐ..Ê¡ÊÂ!!!


Ïà¹ØÎĵµ£º

PL/SQLʵÏÖOracleÊý¾Ý¿âÈÎÎñµ÷¶È

 
     Ñ¡Ôñ×Ô softj µÄ Blog
¹Ø¼ü×Ö
  PL/SQLʵÏÖOracleÊý¾Ý¿âÈÎÎñµ÷¶È
³ö´¦
 
 
PL/SQLʵÏÖOracleÊý¾Ý¿âÈÎÎñµ÷¶È
¡¡¡¡¹Ø¼ü´Ê£ºÊý¾Ý»Ö¸´£¬ÈÎÎñµ÷¶È£¬ORACLE£¬PL/SQL
¡¡¡¡ÔÚÊý¾Ý¿â²Ù×÷ÖÐʱ³£»áÓÐÕâÑùµÄÇé¿ö·¢Éú£¬ÓÉÓÚһʱµÄÊèºö¶øÎóɾ»òÎó¸ÄÁËÒ»Ð©ÖØÒªµÄÊý¾Ý£¬ÁíÍ⻹ÓÐ ......

SQL UnionÓ÷¨×ܽá

UNION ÔËËã·û½«¶à¸ö SELECT Óï¾äµÄ½á¹û×éºÏ³ÉÒ»¸ö½á¹û¼¯¡£ £¨£±£©Ê¹Óà UNION ÐëÂú×ãÒÔÏÂÌõ¼þ£º £Á£ºËùÓвéѯÖбØÐë¾ßÓÐÏàͬµÄ½á¹¹£¨¼´²éѯÖеĵÄÁÐÊýºÍÁеÄ˳Ðò±ØÐëÏàͬ£©¡£ £Â£º¶ÔÓ¦ÁеÄÊý¾ÝÀàÐÍ¿ÉÒÔ²»Í¬µ«ÊDZØÐë¼æÈÝ£¨ËùνµÄ¼æÈÝÊÇÖ¸Á½ÖÖÀàÐÍÖ®¼ä¿ÉÒÔ½øÐÐÒþʽת»»£¬²»ÄܽøÐÐÒþʽת»»Ôò±¨´í£©¡£Ò²¿ÉÒÔÓÃÏÔʽת»»ÎªÏàͬµ ......

ÀûÓÃÕýÔò±í´ïʽʵÏֵļòµ¥µÄÕûÀíSQLÎı¾µÄС¹¤¾ß

ÏÂÔØµØÖ·£º http://download.csdn.net/source/1805903
  private string ReArrange(string str)
{
string[] keywords = new string[] {"select","from","where","and","order\\s+by","or","into",
"update","set","delete","haveing" ......

¡¾×ª¡¿SQL ÓÅ»¯

from£º http://www.javaeye.com/topic/498902?page=1 
×î½ü´ÓÅóÓÑÄÇ¿´ÁËÒ»¸öij×Éѯ¹«Ë¾¸øÒ»¼ÒÆóÒµ×öµÄÒ»¸öÓÅ»¯ÏîÄ¿µÄ×ܽᱨ¸æÊ飬ÆäÀúʱÁ½¸öÔ£¬10Íò·ÑÓã¬4¸öÈË¡£
×îÖÕ½á¹ûÊÇÐÔÄܺÍÏàÓ¦ÌáÉýÁË30%£¬×ܹ²ÐÞ¸ÄÁË3ÐдúÂëºÍÅäÖ㬹²ÐÞ¸ÄÁË3¸öµ¥´Ê£¬²»µ½20¸ö×Öĸ~~~~¡£
ÅóÓÑ×ܽáÁËÒ»¾ä»°£¬¾ÍÊÇ“´úÂëÖÊÁ¿Ô½ÀõÄÏîÄ¿ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ