.







Cenk Yurtseven
 
English Deutsch Türkçe
Language: T-SQL
 Displaying  3.  of  5  Display: 


 
CREATE FULLTEXT CATALOG CREATE FULLTEXT CATALOG Language:  T-SQL 
CREATE FULLTEXT CATALOG

CREATE FULLTEXT CATALOG


--1 Create the Catalog 

CREATE
FULLTEXT CATALOG [TCKimlikNoCatalogs]
IN PATH N'E:SQLServerDataFTCatalogs'
WITH ACCENT_SENSITIVITY = ON
AUTHORIZATION
[dbo]

--2 Add a full text index to a table
EXEC sp_fulltext_table 'TCKimlikNo', 'create', 'TCKimlikNoCatalogs', 'PK_TCKimlikNo'

--3 Add a column to the full text index
EXEC sp_fulltext_column 'TCKimlikNo', 'KIMLIKNO', 'add'
EXEC sp_fulltext_column 'TCKimlikNo', 'ADI', 'add'
EXEC sp_fulltext_column 'TCKimlikNo', 'SOYADI', 'add'
EXEC sp_fulltext_column 'TCKimlikNo', 'ADRESILADI', 'add'
EXEC sp_fulltext_column 'TCKimlikNo', 'ADRESCADDE', 'add'

--4 Activate the index
EXEC sp_fulltext_table 'TCKimlikNo', 'activate'
EXEC sp_fulltext_table 'TCKimlikNo', 'Start_background_updateindex'

--5 Start full population
EXEC sp_fulltext_catalog 'TCKimlikNoCatalogs', 'start_full'





 Displaying  3.  of  5  Display: 


« Previous  1  2  3  4  5  Next »
Member Login  |  Contact Us