Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 ServerÊý¾Ý¿âÖÐËùÓбíÊý¾ÝµÄ·½·¨

Æäʵɾ³ýÊý¾Ý¿âÖÐÊý¾ÝµÄ·½·¨²¢²»¸´ÔÓ£¬ÎªÊ²Ã´ÎÒ»¹Òª¶à´ËÒ»¾ÙÄØ£¬Ò»ÊÇÎÒÕâÀï½éÉܵÄÊÇɾ³ýÊý¾Ý¿âµÄËùÓÐÊý¾Ý£¬ÒòΪÊý¾ÝÖ®¼ä¿ÉÄÜÐγÉÏà»¥Ô¼Êø¹ØÏµ£¬É¾³ý²Ù×÷¿ÉÄÜÏÝÈëËÀÑ­»·£¬¶þÊÇÕâÀïʹÓÃÁË΢ÈíδÕýʽ¹«¿ªµÄsp_MSForEachTable´æ´¢¹ý³Ì¡£
¡¡¡¡Ò²ÐíºÜ¶à¶ÁÕßÅóÓѶ¼¾­Àú¹ýÕâÑùµÄÊÂÇ飺ҪÔÚ¿ª·¢Êý¾Ý¿â»ù´¡ÉÏÇåÀíÒ»¸ö¿Õ¿â£¬µ«ÓÉÓÚ¶ÔÊ ......

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ÎÊÌ⣡

ԭʼÊý¾Ý
 
  
TERMINAL_ID
MAXDATE
TERMINAL_ID
OCCUR_DATE_TIME
TROUBLE_CD
  
1
12345
20100401102754
12345
20100401102754
210
  
2
12345
20100401102754
12345
20100401102754
211
  
3
12345
20100401102754
12345
20100401102754
?09
......

sql¹¤¾ß

×î½üÔÚÓÃsqlcmd¹¤¾ß½øÐÐÊý¾Ý±¸·Ý£¬½ñÌìÔÚ»»µ½sql2000ʱͻȻ²»ÄÜÓá£Ô­À´2000ÊÇûÓÐÕâ¸ö¹¤¾ßµÄ£º
sql2005:
sqlcmd -S ·þÎñÆ÷Ãû»ò·þÎñÆ÷µØÖ· -U Óû§ -P ÃÜÂë -i "ÒýÓõÄsqlÓï¾äÎļþ"
sql2000:¿ÉÒÔÓÃosql´úÌæ£¬¹¦ÄÜÒ»Ñù
osql -S ·þÎñÆ÷Ãû»ò·þÎñÆ÷µØÖ· -U Óû§ -P ÃÜÂë -i "ÒýÓõÄsqlÓï¾äÎļþ" ......

Sql server With

with HostDevice as (----ÉÌ»§Ö÷»ú
select TerminalID ,Deviceid hostDeviceid ,Device.ModelID,Device.SN HostSN,Device.MerchantID,Device.InstallAddress,Device.SoftVersion
from Device
join model HostM on Device.ModelID=HostM.ModelID and HostM.Category in(0,3,4,5,6,8)
--where TerminalID is not null
) ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ