to establish a Full-text index of the title and notes columns of the pubs database, and then use the index query Title column or a notes column that contains a datebase or computer string in the book name:
before this, you need to install the Microsoft Search service to start the SQL Server Full-text Search service
user Pubs--Open database
Go
-Check to see if the database pubs support Full-text indexing if is not supported
-Opens the feature using Sp_fulltext_database
if (select Databaseproperty (' pubs ', ' isfulltextenabled ')) =0
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.