SQL Server defines full-text index

Sp_fulltext_catalog 'doc ', 'create', 'f: \ Temp'
-- Create full-text reference on the ab01 table
Sp_fulltext_table 'doc _ archivesresource', 'create', 'Doc', 'pk _ doc_archivesresource'
-- Add the column za0101 to the ab01 table as the index field, and the index language is simplified Chinese.
Sp_fulltext_column 'doc _ archivesresource', 'memo', 'add', 0x804
-- Activate the disabled full-text index data collection function for ab01
Sp_fulltext_table 'ab01', 'activate ';
-- Disable full-text indexing of ab01, so that full-text indexing data cannot be collected for ab01. The full-text index metadata is retained and can be reactivated.
-- If change tracking is enabled, disabling an active index will freeze the index status: Stop all ongoing fills and no longer spread changes to the index
Sp_fulltext_table 'ab01', 'activate ';
-- Enable incremental filling of full-text indexes
Sp_fulltext_table 'doc _ archivesresource', 'start _ change_tracking'
-- Once a change occurs, the tracked changes will be propagated to the full-text index.
Sp_fulltext_table 'doc _ archivesresource', 'start _ background_updateindex'
Select * From doc_archivesresource 'where ins (za0101, 'anhui ')