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

PL/SQLÌø³öµÄ´íÎó

ÎÒÔÚPL/SQLÀïÃæµã»÷¡°±í¡±£¬ÔÚÓÒ¼üÑ¡Ôñ¡°QUERY¡±

Ìø³öÈçÏ´íÎó£º

ERROR

  Dynamic Performance Tables not accessible,
  Automatic Statistics disabled fro this session

  You can disable statistics in the preference menu,or obtain select
  priviliges on the v$sesstat and v$statname tables


ÕâÊÇʲô´íÎó£¿
Ó¦¸ÃûÓÐÓ°Ïì°É£¬ÕâÀïÓ¦¸ÃÊÇһЩstatisticsµÄÐÅÏ¢£¬Ä㵱ǰÓû§ÎÞ·¨²é¿´¶øÒÑ¡£ ÄãµÄµ±Ç°Óû§¶¼ÓÐʲôȨÏÞѽ¡£

ÒýÓÃ
Ó¦¸ÃûÓÐÓ°Ïì°É£¬ÕâÀïÓ¦¸ÃÊÇһЩstatisticsµÄÐÅÏ¢£¬Ä㵱ǰÓû§ÎÞ·¨²é¿´¶øÒÑ¡£ ÄãµÄµ±Ç°Óû§¶¼ÓÐʲôȨÏÞѽ¡£


ºóÃæµÄ²Ù×÷µ¹ÊÇ¿ÉÒԵģ¨ËäÈ»ÎÒ²»ÖªµÀÒÔºó»á²»»áÓÐÒþ»¼£©

µ«ÊÇÕâ¸ö±íÊÇÓÉÎÒÕâ¸öÕ˺Å×Ô¼º½¨µÄ°¡

Ó¦¸ÃÓÐËùÓÐȨÏÞ°¡


Ïà¹ØÎÊ´ð£º

ÈçºÎÓÃc#£¬sql2000 ¿ª·¢c/sÏµĹ¤×÷Á÷£¿

±¾ÈËc#ÐÂÊÖ ¿ÉÊÇÒªÇóÒªÓÃc# £¬sql2000¿ª·¢c/sµÄ¹¤×÷Á÷£¬Ò»Í·ÎíË®£¬Çë´ó¼Ò°ïæ°ï棬¸øµã˼·£¬ËµµÄÔ¼¾ßÌåÔ½ºÃ£¬ÎÒÒ²ºÃÍùÄǸö·½ÃæÈ¥Ñ§Ï°
http://www.hxzi.com/view/61402.html
B/S°æµÄ£¬»ù±¾Ë¼ÏëÓ¦¸Ã²î²»¶àµÄ¡£¡£ ......

ÇóSQL£¿

´ó¼ÒºÃ£¬ÇëÎÊÔÚ±íMÖÐÓÐ×ֶΣºa b c d e 
ÎÒÏë²é³öÆäÖÐÂú×ãÏÂÃæÈÎÒâÒ»ÏîµÄÊý¾Ý£¬1.×Ö¶Îa µÄÖµ²»ÊÇ ¡®Êé»ò±Ê»ò±¾¡¯ÖÐÈÎÒ»£¬2.aΪÊéµÄʱºò×Ö¶Îb,cÊÇ¿Õ;3.µ±aֵΪ±ÊµÄʱºòdÊÇ¿Õ;4.µ±aΪ±¾µÄʱºòb,d,e¶¼ÊÇ¿Õ;5.È ......

sql server ´æ´¢¹ý³ÌÑ­»·¸³ÖµµÄÎÊÌâ

СµÜÊǸöÐÂÊÖ ÏÖÔÚÓиöÎÊÌâÒ»Ö±²»Äܽâ¾ö
ÀýÈç
procedure produce_proc
    @p001 nvarchar(8000),
    @p002 nvarchar(8000),
    @p003 nvarchar(8000),
  & ......

Çó¼òµ¥sql ÇÀ·Ö

±í A
    sup_code            // ÔÚ¿â
    part_id            // ÐͺÅ
    buy_sup_id    &nbs ......

.net+sqlÊÔÓÿռ䣿£¿

ÎÒÍøÉÏÉêÇëÁËÒ»¸öÄÜÊÔÓÃsqlµÄÍøÖ·£¬°ÑÊý¾Ý¿â±¸·Ý³É1.bak£¬È»ºóÉÏ´«µ½ËûµÄ¿Õ¼ä¸²¸Ç£¬¾ÍÐУ¬È»ºó¸ÄÁËÏÂ.netµÄÁ¬½ÓµØÖ· µ«×ÜÊDz»Äܳɹ¦Á¬½Ó¡£
ºóÀ´ÎÒÄǸöÉêÇë¿Õ¼äµÄ±»¹ØÁË£¬ÏÖÔÚÓÐÔÝÍ£¿Õ¼äµÄÉêÇë

ËùÒÔÇëÎÊÏ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ