Export (0) Print
Expand All

Administering Full-Text Features Using Stored Procedures and Scalar Functions

SQL Server 2000

Administering full-text features using stored procedures and scalar functions is described through examples provided in these topics:

The examples in these topics use two fictitious tables, writers and books, in the pubs database. This table shows the writers table and the columns that are candidates for full-text indexing, specifically the varchar data type.


Column name

Data type
Enable full-text features?
writer_name char(40) No
citizenship char(40) No
organization varchar(100) Yes
royalties_ytd decimal(7,2) No
Royalyties_lifetime decimal(7,2) No
Bio varchar(500) Yes
writer_id integer (with a unique value enforced by the writer_id_index index) No
last_changed timestamp No

This table shows the books table and the columns that are candidates for full-text indexing, specifically the varchar and text data types.


Column name

Data type
Enable full-text features?
writer_name char(40) No
Title varchar(120) Yes
Size smallint No
pub_date datetime No
the_words text Yes
Abstract varchar(500) Yes
isbn char(15) (with a unique value enforced by the isbn_index index) No
last_changed timestamp No

For more information about both querying and indexing, see Example of Combining Full-Text Administration and Full-Text Query.

Show:
© 2014 Microsoft