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

ÌÖÂÛ ²¢·¢Ö´ÐÐSQLʱµÄ¸üжªÊ§£¬ÈçºÎ½â¾öÕâÖÖÎÊÌâ

    ×î½üÓöµ½Ò»¸öÎÊÌ⣬ÔÚ²Ù×÷SQL¸üÐÂÕË»§Óà¶îʱ£¬³£³£·¢ÏÖ¸üкóµÄÓà¶îÓëʵ¼ÊµÄ²»Ïà·û£¬ÂíÉÏÏëµ½ÁËÊDz»ÊÇ´æÔÚ²¢·¢¸üУ¬Ò»²é¹ûÈ»Èç´Ë¡£Ö®Ç°Ò²ÔøÓöµ½¹ýÕâÑùµÄÎÊÌ⣬µ±Ê±Ã»Ì«ÔÚÒ⣬ÏÖÔÚÊǽâ¾öµÄʱºòÁË¡£ÓÃMysqlÄ£ÄâÁËÒ»ÏÂÕâ¸ö¹ý³Ì£º´´½¨Á½ÕÅ±í£¬paralltableºÍparallalter£¬Ã¿´Î¸ù¾Ýparatable±í¸üÐÂparallalter±í£¬ÓÐÈçϼ¸ÌõÂß¼­
    ¢Ù parallProcess.jspÒ³Ãæ½ÓÊÕparall.jsp´«¹ýÀ´µÄÖµ£¬Ê×ÏÈÏòparalltable²åÈëÒ»Ìõ¼Ç¼£¬Í¬Ê±ÓÃparalltableµÄid£¬num£¬Ïòparallalter±í²åÈëÒ»ÌõмǼ£»
    ¢Ú Ö®ºóparallProcess.jsp×¼±¸¸üиղåÈëµÄparalltable¼Ç¼£¬ËæÖ®ÓøüкóµÄparalltableµÄid£¬num£¬Ïòparallalter±í²åÈëÒ»ÌõмǼ£¬µ«ÔÚ¸üÐÂ֮ǰ£¬ÏÈÈËΪµÄÉèÖÃÒ»¸öÑÓʱ£¬ÔÚÑÓʱÆÚÄÚÖ´Ðв¢·¢²Ù×÷¢Û £»
    ¢Û ´Óparall2.jspÒ³ÃæÏòparallProcess2.jspÒ³Ãæ´«Öµ£¬ÔÚparallProcess.jspÑÓʱÆÚÄÚ£¬¸üТÙÖÐÏòparalltable²åÈëµÄ¼Ç¼£¬Í¬Ê±ÓøüкóµÄparalltableµÄid£¬num£¬Ïòparallalter±í²åÈëÒ»ÌõмǼ£»
    ¢Ü Ö´ÐÐÍê¢ÛµÄ²Ù×÷ºó£¬Á¢¿ÌÖ´ÐТڵIJÙ×÷¡£
    Èç´ËµÄ»°£¬¾Í»á·¢ÏÖ±¾À´¢ÛÊÇÔÚ¢ÚÍêȫִÐк󣬶Ôparalltable½øÐиüУ¬½á¹ûÓÉÓÚ²¢·¢²Ù×÷£¬¢ÛµÄ¸üнá¹û¶ªÊ§ÁË£¬ÕâÖÖÎÊÌâÔÚSQL²Ù×÷Öо­³£·¢Éú¡£²»Öª´ó¼ÒÓÐÔÚÓöµ½ÕâÖÖÎÊÌâʱ£¬ÊÇÈçºÎ½â¾öµÄ¡£
¸½£ºÄ£Äâ³ÌÐò¼û  http://download.csdn.net/source/2389003
  


Ïà¹ØÎĵµ£º

SQL SERVERÊý¾ÝÀàÐÍÓëC#Êý¾ÝÀàÐͶÔÕÕ±í

bigint ´Ó -2^63 (-9223372036854775808) µ½ 2^63-1 (9223372036854775807) µÄÕûÐÍÊý¾Ý£¨ËùÓÐÊý×Ö£©¡£´æ´¢´óСΪ 8 ¸ö×Ö½Ú¡£ Int64
int ´Ó -2^31 (-2,147,483,648) µ½ 2^31 - 1 (2,147,483,647) µÄÕûÐÍÊý¾Ý£¨ËùÓÐÊý×Ö£©¡£´æ´¢´óСΪ 4 ¸ö×Ö½Ú¡£int µÄ SQL-92 ͬÒå×ÖΪ integer¡£ Int32
smallint ´Ó -2^15 (-32,768) µ½ ......

SqlÁ¬½Ó²éѯºÍÁªºÏ²éѯ


SqlÁ¬½Ó²éѯºÍÁªºÏ²éѯ
Á¬½Ó²éѯ
   ͨ¹ýÁ¬½ÓÔËËã·û¿ÉÒÔʵÏÖ¶à¸ö±í²éѯ¡£Á¬½ÓÊǹØÏµÊý¾Ý¿âÄ£Ð͵ÄÖ÷ÒªÌØµã£¬Ò²ÊÇËüÇø±ðÓÚÆäËüÀàÐÍÊý¾Ý¿â¹ÜÀíϵͳµÄÒ»¸ö±êÖ¾¡£
   ÔÚ¹ØÏµÊý¾Ý¿â¹ÜÀíϵͳÖУ¬±í½¨Á¢Ê±¸÷Êý¾ÝÖ®¼äµÄ¹ØÏµ²»±ØÈ·¶¨£¬³£°ÑÒ»¸öʵÌåµÄËùÓÐÐÅÏ¢´æ·ÅÔÚÒ»¸ö±íÖС£µ±¼ìË÷Êý¾Ýʱ£¬Í¨¹ýÁ¬½Ó²Ù×÷² ......

ÎÒµÄSQL֮·2

   ÖÁ½ñδÓгɾͣ¬Éõ¸ÐáÝáå¡£
   ²¢²»ÊǺÜͻȻµÄÏëѧSQL£¬¶øÊÇÔÚ֮ǰ˵µÄÄÇÑù£¬ÔÚÎÒÈÆÁËÒ»´óȦ֮ºó£¬²ÅÖªµÀ×Ô¼ºÒ²ÊÇÒ»ÎÞËùÖª£¬Í÷ѧÁËÕâô¶àÄê¡£
   ÎÒÒ»Ö±ÏëÍÑÀëѧУµÄ½ÌÓýģʽÀ´×Ôѧ£¬È»¶øÎÒ²¢²»³ÐÈÏѧУµÄ½ÌÓý·½Ê½ÊÇÒ»ÎÞËùÓõģ¬ÖÁÉÙѧµ½µÄ¶«Î÷ÊÇʵÔڵġ£´ÓѧУµÄ½Ç¶ÈÀ´¿¼ÂÇ£¬ ......

ʹÓÃSQLÓï¾äÉú³ÉÊý¾Ý×Öµä

--sqlserver 2000
SELECT ±íÃû=case when a.colorder=1 then d.name else '' end,
--×Ö¶ÎÐòºÅ=a.colorder,
×Ö¶ÎÃû=a.name,
--
±êʶ=case when COLUMNPROPERTY( a.id,a.name,'IsIdentity')=1 then '√'else '' end,
/**/
Ö÷¼ü=case when exists(SELECT 1 from sysobjects where xtype='PK' and name
in ( ......

PL/SQL ÖеÄSQLÓï¾ä

ÀýÈ磺
ÆÕ±éµÄSQLÓï¾ä£º
          update book set bookname='sssss' where bookId=1;   
ÔÚPL/SQL ÖÐÖ´ÐУº 
          declare
           v_book ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ