Kommentar
Åtkomst till den här sidan kräver auktorisering. Du kan prova att logga in eller ändra kataloger.
Åtkomst till den här sidan kräver auktorisering. Du kan prova att ändra kataloger.
Full-text searches use the CONTAINS predicate to locate rows that have specified text in a given column. Full-Text searches are only possible on columns that have active full-text indexes. If you attempt to use the CONTAINS clause on a column that does not have a currently active full-text index, you will receive an error. For more information on full-text indexes and the CONTAINS clause, see Full-Text Search (SQL Server) and CONTAINS (Transact-SQL).
To create a full-text search query
Open a query from Solution Explorer or create a new one.
In the WHERE clause of your query, use the CONTAINS function to search a full-text column.
See Also
Concepts
Supported Query Types (Visual Database Tools)
Other Resources
Design Queries and Views How-to Topics (Visual Database Tools)
Perform Basic Operations with Queries (Visual Database Tools)