Advertisement
Guest User

Untitled

a guest
Sep 16th, 2014
215
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.66 KB | None | 0 0
  1. CREATE TABLE test(
  2. id int IDENTITY NOT NULL,
  3. value VARCHAR(255),
  4. CONSTRAINT test_pk PRIMARY KEY (id)
  5. );
  6.  
  7. CREATE FULLTEXT INDEX ON [dbo].[Test](
  8. [value] LANGUAGE 'Neutral')
  9. KEY INDEX [test_pk]ON ([test_catalog], FILEGROUP [PRIMARY])
  10. WITH (CHANGE_TRACKING = AUTO, STOPLIST = OFF)
  11.  
  12. INSERT INTO
  13. test (value)
  14. VALUES
  15. ('Selenium_Product_C 01/2014'),
  16. ('Selenium_Product_A 02/2014'),
  17. ('Selenium_Product_A 05/2014'),
  18. ('Selenium_Product_C 10/2014'),
  19. ('Selenium_Product_C 11/2014'),
  20. ('Selenium_Product_C 12/2014');
  21.  
  22. SELECT [KEY] FROM CONTAINSTABLE(Test, value, '"02/2014*"' );
  23.  
  24. SELECT [KEY] FROM CONTAINSTABLE(Test, value, '"01/2014*"' );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement