step 2. type sql Command
Select * from
ex:
select * from Supplier where freetext(Suppliername,'baxi combi')
will return all rows where supplier name contain baxi or combi.
Showing posts with label MS SQL. Show all posts
Showing posts with label MS SQL. Show all posts
Tuesday, February 3, 2009
full text search MS SQL server
step 1. Create full text index on table
step 2. type sql Command
Select * from Where Freetext( , searchText)
ex:
select * from Supplier where freetext(Suppliername,'baxi combi')
will return all rows where supplier name contain baxi or combi.
step 2. type sql Command
Select * from
ex:
select * from Supplier where freetext(Suppliername,'baxi combi')
will return all rows where supplier name contain baxi or combi.
Subscribe to:
Posts (Atom)