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

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ÂÒÂëµÄÎÊÌâ

ÔÚSQL   Server   Unicode×Ö·û´®³£Á¿ÐèҪǰ׺N  
   
  µ±ÔÚSQL  
SERVERÀï±ß´¦Àí×Ö·û´®³£Á¿µÄʱºòÄã±ØÐëÔÚ³£Á¿Ö®Ç°·ÅÒ»¸ö´óдµÄN,¾ÍÏñSQL  
SERVERÁ¬»úÎĵµ±êÌâΪ"²ÉÓÃUnicodeÊý¾Ý"Ëù˵Ã÷µÄÄÇÑù.Nǰ׺ÏóÕ÷×ÅÔÚSQL-92  
±ê×¼µÄ¹ú¼ÒÓïÑÔ,²¢ÇÒ±ØÐëÊÇ´óд×Öĸ.Èç¹ûÄãÔ ......

"SQL Server ²»´æÔÚ»ò·ÃÎʱ»¾Ü¾ø "

"SQL   Server   ²»´æÔÚ»ò·ÃÎʱ»¾Ü¾ø "
Õâ¸öÊÇ×ÔÓµÄ,´íÎó·¢ÉúµÄÔ­Òò±È½Ï¶à,ÐèÒª¼ì²éµÄ·½ÃæÒ²±È½Ï¶à.
Ò»°ã˵À´,ÓÐÒÔϼ¸ÖÖ¿ÉÄÜÐÔ:
1,SQL   ServerÃû³Æ»òIPµØÖ·Æ´Ð´ÓÐÎó
2,·þÎñÆ÷¶ËÍøÂçÅäÖÃÓÐÎó
3,¿Í»§¶ËÍøÂçÅäÖÃÓÐÎó
Òª½â¾öÕâ¸öÎÊÌâ,ÎÒÃÇÒ»°ãÒª×ñÑ­ÒÔϵIJ½ÖèÀ´Ò»²½²½ÕÒ³öµ¼Ö´íÎóµÄÔ­Òò.
= ......

SQL Server ÈÕÆÚºÍʱ¼äº¯Êý


 
1¡¢³£ÓÃÈÕÆÚ·½·¨(ÏÂÃæµÄGetDate() = '2006-11-08 13:37:56.233')
(1)DATENAME ( datepart ,date )
   ·µ»Ø±íʾָ¶¨ÈÕÆÚµÄÖ¸¶¨ÈÕÆÚ²¿·ÖµÄ×Ö·û´®¡£DatepartÏê¼ûÏÂÃæµÄÁбí.
SELECT DateName(day,Getdate()) –·µ»Ø8
(2)DATEPART ( datepart , date )
    ·µ»Ø±íʾָ¶¨ÈÕÆÚµÄÖ¸ ......

sql_map_config.xml(SQL Map»·¾³Îļþ)

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE sqlMapConfig PUBLIC "-//iBATIS.com//DTD SQL Map Config 2.0//EN"
 "http://www.ibatis.com/dtd/sql-map-config-2.dtd">
<sqlMapConfig>
 <!-- ÅäÖúÍÓÅ»¯SQL Map½âÎöʵÀýµÄÉ趨 -->
 <settings cacheModelsEnabled=" ......

ʹÓÃSQL²Ù×÷XML¼òµ¥Ê¾Àý

declare @xml xml
set @xml = '<root/>'
select @xml
declare @value varchar(10)
set @value = 'val1'
set @xml.modify('insert <item value="{sql:variable("@value")}" /> into (/root)[1]')
select @xml
set @value = 'val2'
set @xml.modify('replace value of (/root/item/@value)[1] with "val2 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ