Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- use AdventureWorks
- create fulltext catalog FullTextCatalog as default
- select *
- from sys.fulltext_catalogs
- create fulltext index on Production.ProductDescription(Description)
- key index PK_ProductDescription_ProductDescriptionID
- ALTER TABLE news ADD FULLTEXT(headline, story);
Add Comment
Please, Sign In to add comment