实例演示在SQL数据库中启用全文检索

e pubs
　go

ute sp_fulltext_database 'enable'
　go

ute sp_fulltext_catalog 'ft_titles', 'create'
go

cute sp_fulltext_table 'titles','create', 'ft_titles', 'UPKCL_titleidind'
go

　exec sp_fulltext_column 'titles', 'title', 'add'
go
exec sp_fulltext_column 'titles', 'notes', 'add'
go

　exec sp_fulltext_table 'titles', 'activate'
go

exec sp_fulltext_catalog 'ft_titles', 'start_full'
go

select title, notes from titles
where contains(title, '"computer Cooking"')
go
select title, notes from titles
where freetext(title, 'computer Cooking')
go
select title, notes from titles
where freetext(title, '"computer Cooking"')
go
select title, notes from titles
where contains(title, 'computer')
go
select title, notes from titles
where freetext (*, 'computer')
go