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.
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.
Monday, February 2, 2009
Subscribe to:
Posts (Atom)