![]() To use the neutral language resources, specify 0x0 as language_term. If the language specified is not valid or there are no resources installed that correspond to that language, SQL Server returns an error. If the value is in double-byte character set (DBCS) format, SQL Server converts it to Unicode. The hexadecimal value must not exceed eight digits, including leading zeros. When specified as a hexadecimal value, language_term is 0x followed by the hexadecimal value of the LCID. When specified as an integer, language_term is the actual LCID that identifies the language. The string must be enclosed in single quotation marks, as in ' language_term'. When specified as a string, language_term corresponds to the alias column value in the sys.syslanguages (Transact-SQL) compatibility view. If no value is specified, the column full-text language is used. If language_term is specified, the language it represents is applied to all elements of the search condition. Language_term can be specified as a string, integer, or hexadecimal value corresponding to the LCID of a language. When querying such a column, specifying LANGUAGE language_term can increase the probability of a good match. ![]() If documents of different languages are stored together as binary large objects (BLOBs) in a single column, the locale identifier (LCID) of a given document determines what language to use to index its content. ![]() ![]() Is the language to use for word breaking, stemming, thesaurus expansions and replacements, and noise-word (or stopword) removal as part of the query. For more information, see Search Document Properties with Search Property Lists. Specifies a document property on which to search for the specified search condition.įor the query to return any rows, property_name must be specified in the search property list of the full-text index and the full-text index must contain property-specific entries for property_name. PROPERTY ( column_name, ' property_name')Īpplies to: SQL Server 2012 (11.x) and later. Unless language_term is specified, the language of all columns of the table must be the same. The columns in the CONTAINS clause must come from a single table that has a full-text index. Specifies that the query searches all full-text indexed columns in the table specified in the FROM clause for the given search condition. Unless language_term is specified, the language of all columns of column_list must be the same. column_list must be enclosed in parentheses. Specifies two or more columns, separated by commas. The columns can be of type char, varchar, nchar, nvarchar, text, ntext, image, xml, varbinary, or varbinary(max). ![]() Is the name of a full-text indexed column of the table specified in the FROM clause. To view Transact-SQL syntax for SQL Server 2014 and earlier, see Previous versions documentation. Transact-SQL syntax conventions Syntax CONTAINS ( CONTAINS is a predicate used in the WHERE clause of a Transact-SQL SELECT statement to perform SQL Server full-text search on full-text indexed columns containing character-based data types.Ī word inflectionally generated from another (for example, the word drive is the inflectional stem of drives, drove, driving, and driven).Ī word that is a synonym of another word using a thesaurus (for example, the word "metal" can have synonyms such as "aluminum" and "steel").įor information about the forms of full-text searches that are supported by SQL Server, see Query with Full-Text Search. Searches for precise or fuzzy (less precise) matches to single words and phrases, words within a certain distance of one another, or weighted matches in SQL Server. Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance ![]()
0 Comments
Leave a Reply. |