Roshworld
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.
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment