TAILIEUCHUNG - Microsoft SQL Server 2008 R2 Unleashed- P202

Microsoft SQL Server 2008 R2 Unleashed- P202:SQL Server 2005 provided a number of significant new features and enhancements over what was available in SQL Server 2000. This is not too surprising considering there was a five-year gap between these major SQL Server 2008 is not as much of a quantum leap forward from SQL Server 2005 | 2004 CHAPTER 50 SQL Server Full-Text Search ON FILEGROUP The ON FILEGROUP command is for backward compatibility only. IN PATH The IN PATH command is for backwards compatibility only. WITH ACCENT_SENSITIVITY The WITH ACCENT_SENSITIVITY option allows you to create a catalog that is sensitive Accent_Sensitivity ON to accents the default or insensitive to accents. With Accent_Sensitivity OFF a search on café would match with café and cafe. Likewise a search on cafe would match with cafe and café. With Accent_Sensitivity ON a search on café would match only with café and not cafe. Likewise a search on cafe would match only with cafe and not café. The following is the typical syntax for using the option USE AdventureWorks CREATE FULLTEXT CATALOG MyCatalog ON FILEGROUP MyFileGroup WITH ACCENT_SENSITIVITY OFF AS DEFAULT The AS DEFAULT option allows you to create a default full-text catalog for every full-text index in a database. This option is convenient because you don t have to specify the full-text catalog for your full-text indexes. Ideally each large table will have its own full-text catalog so although it saves some time typing the commands this option is not the best one to use all the time. For example when you create a full-text index at a minimum you need to use the following Use AdventureWorks CREATE FULLTEXT INDEX ON Firstname KEY INDEX pk_Contact_ContactID ON MyCatalog With a default catalog for your database all you have to type is this Use AdventureWorks CREATE FULLTEXT INDEX ON Firstname KEY INDEX pk_Contact_ContactID If you do not have a default catalog you get the following error message Msg 9967 Level 16 State 1 Line 2 A default full-text catalog does not exist in database AdventureWorks or user does not have permission to perform this action. Here is the syntax to create a default catalog Create FullText Catalog AdventureWorksFT as Default NOTE You can have only one default catalog per database. Setting Up a Full-Text .

TỪ KHÓA LIÊN QUAN
Đã phát hiện trình chặn quảng cáo AdBlock
Trang web này phụ thuộc vào doanh thu từ số lần hiển thị quảng cáo để tồn tại. Vui lòng tắt trình chặn quảng cáo của bạn hoặc tạm dừng tính năng chặn quảng cáo cho trang web này.