Guest User

Untitled

a guest
Jul 16th, 2018
88
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.28 KB | None | 0 0
  1. use AdventureWorks
  2. create fulltext catalog FullTextCatalog as default
  3.  
  4. select *
  5. from sys.fulltext_catalogs
  6.  
  7. create fulltext index on Production.ProductDescription(Description)
  8. key index PK_ProductDescription_ProductDescriptionID
  9.  
  10. ALTER TABLE news ADD FULLTEXT(headline, story);
Add Comment
Please, Sign In to add comment