http://sqle.ru/index.php?title=SQL_Server/T-SQL_Tutorial/Data_Types/FULLTEXT&feed=atom&action=history
SQL Server/T-SQL Tutorial/Data Types/FULLTEXT - История изменений
2024-03-29T07:29:05Z
История изменений этой страницы в вики
MediaWiki 1.30.0
http://sqle.ru/index.php?title=SQL_Server/T-SQL_Tutorial/Data_Types/FULLTEXT&diff=7105&oldid=prev
в 13:46, 26 мая 2010
2010-05-26T13:46:16Z
<p></p>
<table class="diff diff-contentalign-left" data-mw="interface">
<tr style="vertical-align: top;" lang="ru">
<td colspan="1" style="background-color: white; color:black; text-align: center;">← Предыдущая</td>
<td colspan="1" style="background-color: white; color:black; text-align: center;">Версия 13:46, 26 мая 2010</td>
</tr><tr><td colspan="2" style="text-align: center;" lang="ru"><div class="mw-diff-empty">(нет различий)</div>
</td></tr></table>
http://sqle.ru/index.php?title=SQL_Server/T-SQL_Tutorial/Data_Types/FULLTEXT&diff=7106&oldid=prev
Admin: 1 версия
2010-05-26T10:25:24Z
<p>1 версия</p>
<p><b>Новая страница</b></p><div>== Creating a Full-Text Index==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
USE YourDatabase<br />
GO<br />
CREATE FULLTEXT CATALOG cat_YourName<br />
CREATE FULLTEXT INDEX ON MyDocumentTable<br />
(DocumentSummary, Document TYPE COLUMN FileExtension)<br />
KEY INDEX PK_DocumentID<br />
ON cat_Document<br />
WITH CHANGE_TRACKING AUTO</source><br />
<br />
<br />
<br />
== Dropping a Full-Text Index==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
DROP FULLTEXT INDEX ON MyDocument</source><br />
<br />
<br />
<br />
== Modifying a Full-Text Index==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
ALTER FULLTEXT INDEX ON MyDocument<br />
ADD (Title)<br />
ALTER FULLTEXT INDEX ON MyDocument<br />
START FULL POPULATION<br />
ALTER FULLTEXT INDEX ON MyDocument<br />
SET CHANGE_TRACKING OFF<br />
ALTER FULLTEXT INDEX ON MyDocument<br />
DROP (Title)</source><br />
<br />
<br />
<br />
== Using FREETEXT to Search Full-Text Indexed Columns==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
3><br />
4> CREATE TABLE employee(<br />
5> id INTEGER NOT NULL PRIMARY KEY,<br />
6> first_name VARCHAR(10),<br />
7> last_name VARCHAR(10),<br />
8> salary DECIMAL(10,2),<br />
9> start_Date DATETIME,<br />
10> region VARCHAR(10),<br />
11> city VARCHAR(20),<br />
12> managerid INTEGER<br />
13> );<br />
14> GO<br />
1> INSERT INTO employee VALUES (1, "Jason" , "Martin", 5890,"2005-03-22","North","Vancouver",3);<br />
2> GO<br />
(1 rows affected)<br />
1> INSERT INTO employee VALUES (2, "Alison", "Mathews",4789,"2003-07-21","South","Utown",4);<br />
2> GO<br />
(1 rows affected)<br />
1> INSERT INTO employee VALUES (3, "James" , "Smith", 6678,"2001-12-01","North","Paris",5);<br />
2> GO<br />
(1 rows affected)<br />
1> INSERT INTO employee VALUES (4, "Celia" , "Rice", 5567,"2006-03-03","South","London",6);<br />
2> GO<br />
(1 rows affected)<br />
1> INSERT INTO employee VALUES (5, "Robert", "Black", 4467,"2004-07-02","East","Newton",7);<br />
2> GO<br />
(1 rows affected)<br />
1> INSERT INTO employee VALUES (6, "Linda" , "Green" , 6456,"2002-05-19","East","Calgary",8);<br />
2> GO<br />
(1 rows affected)<br />
1> INSERT INTO employee VALUES (7, "David" , "Larry", 5345,"2008-03-18","West","New York",9);<br />
2> GO<br />
(1 rows affected)<br />
1> INSERT INTO employee VALUES (8, "James" , "Cat", 4234,"2007-07-17","West","Regina",9);<br />
2> GO<br />
(1 rows affected)<br />
1> INSERT INTO employee VALUES (9, "Joan" , "Act", 6123,"2001-04-16","North","Toronto",10);<br />
2> GO<br />
(1 rows affected)<br />
1><br />
2> select * from employee;<br />
3> GO<br />
id first_name last_name salary start_Date region city managerid<br />
----------- ---------- ---------- ------------ ----------------------- ---------- -------------------- -----------<br />
1 Jason Martin 5890.00 2005-03-22 00:00:00.000 North Vancouver 3<br />
2 Alison Mathews 4789.00 2003-07-21 00:00:00.000 South Utown 4<br />
3 James Smith 6678.00 2001-12-01 00:00:00.000 North Paris 5<br />
4 Celia Rice 5567.00 2006-03-03 00:00:00.000 South London 6<br />
5 Robert Black 4467.00 2004-07-02 00:00:00.000 East Newton 7<br />
6 Linda Green 6456.00 2002-05-19 00:00:00.000 East Calgary 8<br />
7 David Larry 5345.00 2008-03-18 00:00:00.000 West New York 9<br />
8 James Cat 4234.00 2007-07-17 00:00:00.000 West Regina 9<br />
9 Joan Act 6123.00 2001-04-16 00:00:00.000 North Toronto 10<br />
(9 rows affected)<br />
1><br />
2> ALTER FULLTEXT INDEX ON Employee<br />
3> ADD (First_Name)<br />
4> GO<br />
Msg 7609, Level 17, State 104, Server BCE67B1242DE45A\SQLEXPRESS, Line 2<br />
Full-Text Search is not installed, or a full-text component cannot be loaded.<br />
1><br />
2> SELECT ID<br />
3> FROM Employee<br />
4> WHERE FREETEXT (First_Name, "c" )<br />
5> GO<br />
Msg 7601, Level 16, State 2, Server BCE67B1242DE45A\SQLEXPRESS, Line 2<br />
Cannot use a CONTAINS or FREETEXT predicate on table or indexed view "Employee" because it is not full-text indexed.<br />
1><br />
2><br />
3> drop table employee;<br />
4> GO<br />
1></source></div>
Admin