全文索引.sql

这是用ASP+SQL+HTML+XML写的

SELECT *
FROM ToysDetails
WHERE CONTAINS(*, '"gam*"')

SELECT *
FROM ToysDetails
WHERE   
 freetext(*, '"game"')

SELECT *
FROM  CONTAINStable(ToysDetails,*, '"gam*"')

SELECT *
FROM    
 freetexttable(ToysDetails,*, '"game"')