22 Samh 2024 · 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 …

Specifies that a series of Transact-SQL statements, which together don't produce a side effect such as modifying a table, define the value of the function. function_body is used only in scalar …

29 MFómh 2025 · Learn about the categories of built-in functions you can use with SQL databases. You can use the built-in functions or create your own user-defined functions.

7 Iúil 2025 · Use the functions described in this article to match complex patterns and manipulate data in SQL Server with regular expressions.

Azure Cosmos DB for NoSQL provides many built-in system functions for common tasks across a wide variety of categories.

23 Beal 2023 · All built-in string functions except FORMAT are deterministic. This means they return the same value any time they are called with a specific set of input values. For more …

28 DFómh 2025 · The JSON_CONTAINS function searches for a SQL value in a path in a JSON document.

Functions that return system date and time values Transact-SQL derives all system date and time values from the operating system of the computer on which the instance of SQL Server runs.

15 Aib 2024 · Learn about using the contains function in an XQuery to determine whether a specified string value contains the specified substring value.

16 Aib 2025 · The SUBSTRING function returns a portion of a specified character, binary, text, or image expression.