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

Sql server 2000 µÄµÈ´ýÏìӦʱ¼ä

     ǰһ¶Îʱ¼äÔÚά»¤Ò»¸öÀÏÏîÄ¿µÄʱºò·¢ÏÖ£¬ÔÚÖ´ÐÐÒ»¸ö½Ï´óµÄ´æ´¢¹ý³Ìʱ£¬×ÜÊDZ¨“³£¹æÍøÂç´íÎó£¬Çë¼ì²éÄúµÄÍøÂçÎĵµ”¡£ÔÚºóÐøµÄά»¤¼ì²éÖз¢ÏÖ£¬ÊÇÊÂÎﳬʱµ¼ÖÂÖ´ÐÐÖÐÖ¹µÄ¡£
     ÏÂÃæÊǵ÷Õû¹ý³Ì£º
      Ò»¡¢°ÑSQL SERVERµÄµÈ´ýÏìӦʱ¼äµ÷µ½×î´óÖµ
       show advanced options Ñ¡Ï
       show advanced options Ñ¡ÏîÓÃÀ´ÏÔʾ sp_configure ϵͳ´æ´¢¹ý³Ì¸ß¼¶Ñ¡Ïî¡£
       µ±ÉèÖà show advanced options Ϊ 1 ʱ£¬²Å¿ÉÒÔʹÓà sp_configure Áгö¸ß¼¶Ñ¡Ïî¡£
       ĬÈÏֵΪ 0¡£¸ÃÉèÖÃÁ¢¼´ÉúЧ£¨ÎÞÐèÍ£Ö¹²¢ÖØÐÂÆô¶¯·þÎñÆ÷£©¡£
       Ö´ÐÐSQLÓï¾ä
       sp_configure  'show advanced options',  1
       GO
       RECONFIGURE
       GO
       query wait Ñ¡Ï
       query wait Ñ¡Ïî¿ÉÒÔÉ趨һ¸ö²éѯÔÚ³¬Ê±Ç°µÈ´ýËùÐè×ÊÔ´µÄʱ¼ä
                     £¨ÒÔÃëΪµ¥Î»£¬·¶Î§´Ó 0 µ½2147483647£©¡£
       Èç¹ûʹÓÃĬÈÏÖµ –1 »òÖ¸¶¨ –1£¬Ôò³¬Ê±Ê±¼äͨ¹ý¼ÆËãµÃµ½£¬ÊÇÔ¤¼Æ²éѯ³É±¾µÄ 25 ±¶¡£
¡¡¡¡¡¡Ö´ÐУӣѣÌÓï¾ä
¡¡¡¡¡¡sp_configure  'query wait',  2147483647
¡¡¡¡¡¡GO
¡¡¡¡¡¡RECONFIGURE
¡¡¡¡¡¡GO
¡¡¡¡¶þ¡¢Èç¹ûÔÚ.NETÖе÷Óô洢¹ý³ÌµÄ»°£¬Èç¹ûÄãÖ»ÊÇÉÏÃæµÄÖµÉèÖÃÒ»ÏµĻ°£¬ÔÚ.NETÖÐÒ²ÒªÔÙÐÞ¸Äһϣ¬²Å¿ÉÒÔ£¬²»È»ÔÚ.NETÖÐĬÈϺÃÏñÊÇ30Ã룬µ±ÄãµÄ´æ´¢¹ý³ÌÖ´Ðг¬¹ýÕâ¸öʱ¼äµÄʱºò¾Í»á±¨´í¡£ºÃÏñ¿´µ½ÍøÂçÉϱðÈË˵ÉèÖÃΪ0£¬Ëü¿ÉÒÔ×î´óÖµ£¬µ«ÎÒÉèÖúÃÏñûЧ¹û£¬Ö»ÄܸøËüÒ»¸ö¹»´óµÄÖµ¾Í¿ÉÒÔÁË¡£ÈçÔÚ.NETÖе÷ÓÃNBAÕâ¸ö´æ´¢¹ý³Ì¡£ÉèÖÃËüµÄ×î´óʱ¼ä´úÂëÈçÏ£º                      &n


Ïà¹ØÎĵµ£º

SQL ¼Ü¹¹

¼Ü¹¹£¨Schema£©¡£Î¢ÈíµÄ¹Ù·½ËµÃ÷£¨MSDN£©£º
"Êý¾Ý¿â¼Ü¹¹ÊÇÒ»¸ö¶ÀÁ¢ÓÚÊý¾Ý¿âÓû§µÄ·ÇÖØ¸´ÃüÃû¿Õ¼ä£¬Äú¿ÉÒÔ½«¼Ü¹¹ÊÓΪ¶ÔÏóµÄÈÝÆ÷"£¬Ïêϸ²Î¿¼
http://technet.microsoft.com/zh-cn/library/ms190387.aspx.ÎÒÃÇÖªµÀ£¬ÔÚJAVAÖУ¬ÃüÃû¿Õ
¼äÃûÆäʵ¾ÍÊÇÎļþ¼ÐÃû¡£Òò´ËÎÒÃǷdz£Ã÷È·Ò»µã£ºÒ»¸ö¶ÔÏóÖ»ÄÜÊôÓÚÒ»¸ö¼Ü¹¹£¬¾ÍÏ ......

SQL »ù±¾²Ù×÷ ɾ³ý ÐÞ¸Ä Ë¢Ð Ð޸İæ

C# Êý¾Ý¿âÖ®ÂÃ……
¼ÌÐø½ø¹¥²ã³ö²»ÇîµÄproblems
ÔÚÉÏһƪÄÚÈݵĻù´¡ÉÏ£¬ÎÒÓÖ×÷ÒԸĽø£¬ÏÖÔÚµÄÇé¿öÊÇÕâÑùµÄ£º
 //In Browseuser form
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System ......

VS2005×Ô´øSQL ExpressÅäÖÃ

ÏÂÃæÊDzÙ×÷²½Ö裺
1. “·þÎñºÍÁ¬½ÓµÄÍâΧӦÓÃÅäÖÓ -¡·“±¾µØÁ¬½ÓºÍÔ¶³ÌÁ¬½Ó”-¡·“ͬʱʹÓÃTCP/IPºÍNamed Pipes“£»
2. “·þÎñÅäÖùÜÀíÆ÷”-¡·“ÍøÂçÅäÖÔ-¡·“SQL ExpressµÄЭÒé“-¡·“IPµØÖ·”£¬½«IpAll Tcp¶Ë¿Ú¸ÄΪ1433£»
3.  ÖØÆô·þ ......

·À·¶sql×¢Èë¹¥»÷£¨ÉÏ£©

ͬ²½Ò»ÏÂÎÒbaiduµÄblog£ºhttp://hi.baidu.com/ncheng/blog/item/bc65f82a1a6a7c335343c11c.html
Sql×¢ÈëÊÇÒ»ÖÖÈëÃż«µÍÆÆ»µ¼«´óµÄ¹¥»÷·½Ê½¡£Èç¹ûsqlÊÇÓÃ×Ö·û´®Æ´½Ó³öÀ´µÄ»°£¬ÄÇô¿Ï¶¨»á±»×¢Èë¹¥»÷£¬Ç°¶Îʱ¼ä»¹´«³öÁËij¹úÍâ´óÐÍÉç½»ÍøÕ¾±»SQL×¢Èë¹¥»÷¡£
Sql×¢Èë¹¥»÷µÄ·½Ê½£¬À´ÕâÀï¿´µÄͬ־ÃÇÓ¦¸ÃºÜÇå³þÁË£¬¾ÍÊÇÔÚÆ´½Ó×Ö·û´ ......

ʹÓÃsqlÓï¾ä»ñµÃµ±Ç°ÔÂÌìÊý


 Ê¹ÓÃsqlÓï¾ä»ñµÃµ±Ç°ÔÂÌìÊý
   --»ñµÃµ±ÔÂÌìÊý  
    select day(dateadd(mm,1,getdate())-day(getdate())) as ±¾ÔÂÌìÊý ;  
    select getdate() as µ±Ç°ÈÕÆÚ;  
  &nb ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ