Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE test(
- id int IDENTITY NOT NULL,
- value VARCHAR(255),
- CONSTRAINT test_pk PRIMARY KEY (id)
- );
- CREATE FULLTEXT INDEX ON [dbo].[Test](
- [value] LANGUAGE 'Neutral')
- KEY INDEX [test_pk]ON ([test_catalog], FILEGROUP [PRIMARY])
- WITH (CHANGE_TRACKING = AUTO, STOPLIST = OFF)
- INSERT INTO
- test (value)
- VALUES
- ('Selenium_Product_C 01/2014'),
- ('Selenium_Product_A 02/2014'),
- ('Selenium_Product_A 05/2014'),
- ('Selenium_Product_C 10/2014'),
- ('Selenium_Product_C 11/2014'),
- ('Selenium_Product_C 12/2014');
- SELECT [KEY] FROM CONTAINSTABLE(Test, value, '"02/2014*"' );
- SELECT [KEY] FROM CONTAINSTABLE(Test, value, '"01/2014*"' );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement