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
    
     
	
	
    
    
	Ïà¹ØÎĵµ£º
        
    
    ¼Ü¹¹£¨Schema£©¡£Î¢ÈíµÄ¹Ù·½ËµÃ÷£¨MSDN£©£º
"Êý¾Ý¿â¼Ü¹¹ÊÇÒ»¸ö¶ÀÁ¢ÓÚÊý¾Ý¿âÓû§µÄ·ÇÖØ¸´ÃüÃû¿Õ¼ä£¬Äú¿ÉÒÔ½«¼Ü¹¹ÊÓΪ¶ÔÏóµÄÈÝÆ÷"£¬Ïêϸ²Î¿¼
http://technet.microsoft.com/zh-cn/library/ms190387.aspx.ÎÒÃÇÖªµÀ£¬ÔÚJAVAÖУ¬ÃüÃû¿Õ
¼äÃûÆäʵ¾ÍÊÇÎļþ¼ÐÃû¡£Òò´ËÎÒÃǷdz£Ã÷È·Ò»µã£ºÒ»¸ö¶ÔÏóÖ»ÄÜÊôÓÚÒ»¸ö¼Ü¹¹£¬¾ÍÏ ......
	
    
        
    
    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 ......
	
    
        
    
    ÏÂÃæÊDzÙ×÷²½Ö裺
1. “·þÎñºÍÁ¬½ÓµÄÍâΧӦÓÃÅäÖÓ -¡·“±¾µØÁ¬½ÓºÍÔ¶³ÌÁ¬½Ó”-¡·“ͬʱʹÓÃTCP/IPºÍNamed Pipes“£»
2. “·þÎñÅäÖùÜÀíÆ÷”-¡·“ÍøÂçÅäÖÔ-¡·“SQL ExpressµÄÐÒé“-¡·“IPµØÖ·”£¬½«IpAll Tcp¶Ë¿Ú¸ÄΪ1433£»
3.  ÖØÆô·þ ......
	
    
        
    
    ͬ²½Ò»ÏÂÎÒbaiduµÄblog£ºhttp://hi.baidu.com/ncheng/blog/item/bc65f82a1a6a7c335343c11c.html
Sql×¢ÈëÊÇÒ»ÖÖÈëÃż«µÍÆÆ»µ¼«´óµÄ¹¥»÷·½Ê½¡£Èç¹ûsqlÊÇÓÃ×Ö·û´®Æ´½Ó³öÀ´µÄ»°£¬ÄÇô¿Ï¶¨»á±»×¢Èë¹¥»÷£¬Ç°¶Îʱ¼ä»¹´«³öÁËij¹úÍâ´óÐÍÉç½»ÍøÕ¾±»SQL×¢Èë¹¥»÷¡£
Sql×¢Èë¹¥»÷µÄ·½Ê½£¬À´ÕâÀï¿´µÄͬ־ÃÇÓ¦¸ÃºÜÇå³þÁË£¬¾ÍÊÇÔÚÆ´½Ó×Ö·û´ ......
	
    
        
    
    
 Ê¹ÓÃsqlÓï¾ä»ñµÃµ±Ç°ÔÂÌìÊý
   --»ñµÃµ±ÔÂÌìÊý  
    select day(dateadd(mm,1,getdate())-day(getdate())) as ±¾ÔÂÌìÊý ;  
    select getdate() as µ±Ç°ÈÕÆÚ;  
  &nb ......