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¸ö£¨Ð©£©Êý¾Ý±íµÄ½øÐÐÈ«ÎļìË÷ÉèÖúó£¬ÔÙÅäºÏϵͳÀïµÄÈ«ÎļìË÷ÉèÖ㬾ͿÉÒÔÕâ¸ö£¨Ð©£©±í½øÐÐÈ«ÎļìË÷ÁË¡£
Ïà¹ØÎĵµ£º
Æäʵɾ³ýÊý¾Ý¿âÖÐÊý¾ÝµÄ·½·¨²¢²»¸´ÔÓ£¬ÎªÊ²Ã´ÎÒ»¹Òª¶à´ËÒ»¾ÙÄØ£¬Ò»ÊÇÎÒÕâÀï½éÉܵÄÊÇɾ³ýÊý¾Ý¿âµÄËùÓÐÊý¾Ý£¬ÒòΪÊý¾ÝÖ®¼ä¿ÉÄÜÐγÉÏà»¥Ô¼Êø¹ØÏµ£¬É¾³ý²Ù×÷¿ÉÄÜÏÝÈëËÀÑ»·£¬¶þÊÇÕâÀïʹÓÃÁË΢ÈíδÕýʽ¹«¿ªµÄsp_MSForEachTable´æ´¢¹ý³Ì¡£
¡¡¡¡Ò²ÐíºÜ¶à¶ÁÕßÅóÓѶ¼¾Àú¹ýÕâÑùµÄÊÂÇ飺ҪÔÚ¿ª·¢Êý¾Ý¿â»ù´¡ÉÏÇåÀíÒ»¸ö¿Õ¿â£¬µ«ÓÉÓÚ¶ÔÊ ......
<?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=" ......
ÔʼÊý¾Ý
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
......
×î½üÔÚÓÃsqlcmd¹¤¾ß½øÐÐÊý¾Ý±¸·Ý£¬½ñÌìÔÚ»»µ½sql2000ʱͻȻ²»ÄÜÓá£ÔÀ´2000ÊÇûÓÐÕâ¸ö¹¤¾ßµÄ£º
sql2005:
sqlcmd -S ·þÎñÆ÷Ãû»ò·þÎñÆ÷µØÖ· -U Óû§ -P ÃÜÂë -i "ÒýÓõÄsqlÓï¾äÎļþ"
sql2000:¿ÉÒÔÓÃosql´úÌæ£¬¹¦ÄÜÒ»Ñù
osql -S ·þÎñÆ÷Ãû»ò·þÎñÆ÷µØÖ· -U Óû§ -P ÃÜÂë -i "ÒýÓõÄsqlÓï¾äÎļþ" ......
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
) ......