发表于 2009-1-5 19:48
| 
濡備綍浣跨敤SQL Server 2000鍏ㄦ枃妫绱
鍙戝竷: 2008-6-30 23:26 | 浣滆: admin | 鏌ョ湅: 28娆
濡備綍浣跨敤SQL Server 2000鍏ㄦ枃妫绱
鐑 鑽
銆愬瓧浣擄細灏 澶с
濡備綍浣跨敤SQL Server 2000鍏ㄦ枃妫绱
浣滆咃細- 鏂囩珷鏉ユ簮锛- 鐐瑰嚮鏁帮細2150 鏇存柊鏃堕棿锛2006-4-20 
SQL Server 2000鍏ㄦ枃妫绱
涓銆佸浣曞湪SQL涓惎鐢ㄥ叏鏂囨绱㈠姛鑳
1銆佽瘉鍏ㄦ枃妫绱㈡湇鍔℃槸鍚﹀畨瑁
閫氳繃鍌ㄥ瓨杩囩▼FULLTEXTSERVICEPROPERTY锛堣繑鍥炴湁鍏冲叏鏂囨湇鍔＄骇鍒睘鎬х殑淇℃伅锛夋潵楠岃瘉鎼滅储鏈嶅姟锛堝叏鏂囩粍浠讹級鏄惁瀹夎銆傚Select fulltextserviceproperty (IsFullTextInstalled)锛氳繑鍥1琛ㄧず宸插畨瑁呭叏鏂囩粍浠讹紱杩斿洖0琛ㄧず鏈畨瑁呭叏鏂囩粍浠讹紱杩斿洖Null琛ㄧず杈撳叆鏃犳晥鎴栧彂鐢熼敊璇
2銆佸惎鍔ㄥ叏鏂囨绱㈡湇鍔★紙MircoSoft Search锛
3銆佹墦寮鏁版嵁搴撳叏鏂囩储寮曠殑鏀寔
涓哄叏鏂囩储寮曞惎鐢ㄦ暟鎹簱锛
Use Northwind
Exec sp_fulltext_database enable
浠庢暟鎹簱涓垹闄ゆ墍鏈夌洰褰曪細
Use Northwind
Exec sp_fulltext_database disable
浜屻佸缓绔嬪叏鏂囩洰褰
1銆佸垱寤哄叏鏂囩洰褰
Use Northwind
Exec sp_fulltext_catalog 'ft_ Catalog ', 'create'
2銆侀噸寤哄叏鏂囩洰褰
Use Northwind
Exec sp_fulltext_catalog 'ft_ Catalog ', ' rebulid'
3銆佸惎鍔ㄥ叏鏂囩洰褰曠殑濉厖
Use Northwind
Exec sp_fulltext_catalog 'ft_ Catalog ', 'start_full'
4銆佸仠姝㈠叏鏂囩洰褰曠殑濉厖
Use Northwind
Exec sp_fulltext_catalog 'ft_ Catalog ', 'stop'
5銆佸垹闄ゅ叏鏂囩洰褰
Use Northwind
PK_Products
Exec sp_fulltext_catalog 'ft_ Catalog ', 'drop'
涓夈佷负琛ㄥ缓绔嬪叏鏂囩储寮曟暟鎹厓
1銆佸缓绔嬬殑鍞竴绱㈠紩
Use Northwind
Exec sp_fulltext_table 'Products','create', 'ft_ Catalog', ' PK_Products '
2銆佽缃叏鏂囩储寮曞垪鍚
Use Northwind
Exec sp_fulltext_table 'Products','create', 'ft_ Catalog', ' PK_Products '
3銆佽缃叏鏂囩储寮曞垪鍚
Use Northwind
Exec sp_fulltext_column ' Products ', ProductName', 'add'
Go
Exec sp_fulltext_column ' Products ', QuantityPerUnit', 'add'
Go
4銆佹縺娲诲叏鏂囩储寮
Use Northwind
Exec sp_fulltext_table 'Products','activate
5銆佸～鍏呭叏鏂囩储寮曠洰褰
Use Northwind
Exec sp_fulltext_catalog 'ft_ Catalog ', 'start_full'
鍥涖佷娇鐢═ransact-SQL杩涜鍏ㄦ枃妫绱紝鎴戜滑浣跨敤CONTAINS銆丗REETEXT绛夎皳璇
1銆佹绱roductName涓紝鍗冲寘鍚玝鍙堝寘鍚玞鐨勬墍鏈夊垪
Use Northwind
SELECT *
FROM Products
WHERE CONTAINS(ProductName, '"c*" and "b*" ')
2銆佹绱roductName涓紝鍗冲寘鍚玞hai chang tofu涔嬩竴鐨勬墍鏈夊垪
Use Northwind
SELECT *
FROM Products
WHERE FREETEXT(ProductName, 'chai chang tofu ')
浜斻佸叏鏂囨煡璇㈡湁鍏崇殑绯荤粺瀛樺偍杩囩▼
锛1锛夊惎鍔ㄦ暟鎹簱鐨勫叏鏂囧鐞嗗姛鑳斤紙sp_fulltext_datebase锛夛紱
锛2锛夊缓绔嬪叏鏂囩洰褰曪紙sp_fulltext_catalog锛夛紱
锛3锛夊湪鍏ㄦ枃鐩綍涓敞鍐岄渶瑕佸叏鏂囩储寮曠殑琛紙sp_fulltext_table锛夛紱
锛4锛夋寚鍑鸿〃涓渶瑕佸叏鏂囨绱㈢殑鍒楀悕锛坰p_fulltext_column锛
锛5锛変负琛ㄥ垱寤哄叏鏂囩储寮曪紙sp_fulltext_table锛夛紱
锛6锛夊～鍏呭叏鏂囩储寮曪紙sp_fulltext_catalog锛夈
鍏ㄦ枃鏌ヨ鏀寔
Microsoft
