SQL Server 2005 ÖÐÈçºÎ×öÈ«ÎļìË÷
	
    
    
	1¡¢²é¿´µ±Ç°Êý¾Ý¿âµÄ״̬
       SELECT
 DATABASEPROPERTY
 ('pubs'
,'IsFulltextEnabled'
)
 2¡¢´ò¿ªFullText¹¦ÄÜ
       sp_fulltext_databse
 'enable'
       ¹Ø±Õ´Ë¹¦ÄÜ
      sp_fulltext_databse
 
'disable'
 3¡¢½¨Á¢Ò»¸öUniqueµÄIndex¡£
      ÔÚModify 
Table½çÃæÖУ¬Êó±êÓÒ¼ü£¬Ñ¡ÔñIndex/Keys...
       
       ÔÚColumnsÖÐÑ¡Ôñ×ֶΣ¬TypeÑ¡ÔñUnique Key¡£
      
4¡¢½ÓÏÂÀ´¾Í¿ÉÒÔ¶¨ÒåÈ«ÎļìË÷ÁË£¬ÈçÏÂͼѡÔñDefine Full-Text 
Index...
      
      ½ÓÏÂÀ´¾ÍÊÇÏòµ¼½çÃæÁË£¬°´ÕÕÏòµ¼Ò»²½Ò»²½×ö£¬¾Í²»»á´íÁË£¡
      
 
      Ñ¡Ôñ¸Õ²Å¶¨ÒåµÄUnique Index¡£
      
      Ñ¡ÔñÄãÒªÓÃÀ´È«ÎļìË÷µÄ×ֶΡ£
      
      £¨Õâ¸öÔÝʱÎÒ»¹²»ÖªµÀ£¬Ï´ÎÁ˽âÁËÔÙÀ´²¹³ä¡££©
      
      Ñ¡ÔñĿ¼
      
      ´´½¨µ÷¶È
      
      È«ÎļìË÷Íê³É£¬µã»÷Finish½øÐн¨Á¢¡£
      
      ¿ªÊ¼½¨Á¢¡£
      
5¡¢Æô¶¯ÍêÈ«Ìî³ä
      
      
×ܽ᣺
ÎÒÃÇÔÚ¶ÔSQL 
ServerÉϵÄij¸öÊý¾Ý¿âϵÄij¸ö£¨Ð©£©Êý¾Ý±íµÄ½øÐÐÈ«ÎļìË÷ÉèÖúó£¬ÔÙÅäºÏϵͳÀïµÄÈ«ÎļìË÷ÉèÖ㬾ͿÉÒÔÕâ¸ö£¨Ð©£©±í½øÐÐÈ«ÎļìË÷ÁË¡£
    
     
	
	
    
    
	Ïà¹ØÎĵµ£º
        
    
    "SQL   Server   ²»´æÔÚ»ò·ÃÎʱ»¾Ü¾ø " 
Õâ¸öÊÇ×ÔÓµÄ,´íÎó·¢ÉúµÄÔÒò±È½Ï¶à,ÐèÒª¼ì²éµÄ·½ÃæÒ²±È½Ï¶à. 
Ò»°ã˵À´,ÓÐÒÔϼ¸ÖÖ¿ÉÄÜÐÔ: 
1,SQL   ServerÃû³Æ»òIPµØÖ·Æ´Ð´ÓÐÎó 
2,·þÎñÆ÷¶ËÍøÂçÅäÖÃÓÐÎó 
3,¿Í»§¶ËÍøÂçÅäÖÃÓÐÎó 
Òª½â¾öÕâ¸öÎÊÌâ,ÎÒÃÇÒ»°ãÒª×ñÑÒÔϵIJ½ÖèÀ´Ò»²½²½ÕÒ³öµ¼Ö´íÎóµÄÔÒò. 
= ......
	
    
        
    
    
 
1¡¢³£ÓÃÈÕÆÚ·½·¨(ÏÂÃæµÄGetDate() = '2006-11-08 13:37:56.233')
(1)DATENAME ( datepart ,date )
   ·µ»Ø±íʾָ¶¨ÈÕÆÚµÄÖ¸¶¨ÈÕÆÚ²¿·ÖµÄ×Ö·û´®¡£DatepartÏê¼ûÏÂÃæµÄÁбí.
SELECT DateName(day,Getdate()) –·µ»Ø8 
(2)DATEPART ( datepart , date )
    ·µ»Ø±íʾָ¶¨ÈÕÆÚµÄÖ¸ ......
	
    
        
    
    ×î½üÔÚÓÃsqlcmd¹¤¾ß½øÐÐÊý¾Ý±¸·Ý£¬½ñÌìÔÚ»»µ½sql2000ʱͻȻ²»ÄÜÓá£ÔÀ´2000ÊÇûÓÐÕâ¸ö¹¤¾ßµÄ£º
sql2005: 
sqlcmd -S ·þÎñÆ÷Ãû»ò·þÎñÆ÷µØÖ· -U Óû§ -P ÃÜÂë -i "ÒýÓõÄsqlÓï¾äÎļþ"
sql2000:¿ÉÒÔÓÃosql´úÌæ£¬¹¦ÄÜÒ»Ñù
osql -S ·þÎñÆ÷Ãû»ò·þÎñÆ÷µØÖ· -U Óû§ -P ÃÜÂë -i "ÒýÓõÄsqlÓï¾äÎļþ" ......
	
    
        
    
    Entity sql ²éѯ·ÖÎöÆ÷
1¡¢eSqlBlast for VS 2008 SP1 ¿ªÔ´ 
download£ºhttp://code.msdn.microsoft.com/esql/Release/ProjectReleases.aspx?ReleaseId=991
Ó÷¨£ºhttp://www.cnblogs.com/xiaomi7732/archive/2008/09/09/1287952.html
2¡¢LINQPad
Ö÷Ò³ http://www.linqpad.net/
²»½öÖ§³Ö entity sql £¬»¹Ö§³ÖLinq £¬s ......
	
    
        
    
    TOP ÔöÇ¿¹¦ÄÜ 
1¡¢TOP ÔöÇ¿¡£¿ÉÒÔÖ¸¶¨Ò»¸öÊý×Ö±í´ïʽ£¬ÒÔ·µ»ØÒªÍ¨¹ý²éѯӰÏìµÄÐÐÊý»ò°Ù·Ö±È£¬»¹¿ÉÒÔ¸ù¾ÝÇé¿öʹÓñäÁ¿»ò×Ó²éѯ¡£ 
¿ÉÒÔÔÚDELETE¡¢UPDATEºÍINSERT²éѯÖÐʹÓÃTOPÑ¡Ïî¡£ 
2¡¢¸üºÃµØÌæ»»SET ROWCOUNTÑ¡Ïʹ֮¸üΪÓÐЧ¡£ 
OUTPUT 
1¡¢SQL Server 2005ÒýÈëÒ»¸öеÄOUTPUT×Ӿ䣬ÒÔʹÄú¿ÉÒÔ³åÐÞ¸ÄÓï¾ä(INSERT¡ ......