Search results
Learn how to use built-in functions in SQL Server for string, numeric, date, conversion, and advanced operations. See the function description, syntax, and examples for each function.
23 maj 2023 · SQL Server built-in functions are either deterministic or nondeterministic. Functions are deterministic when they always return the same result anytime they're called by using a specific set of input values.
26 kwi 2024 · Function accesses user data in the local instance of SQL Server. Includes user-defined tables and temp tables, but not table variables. The precision and determinism properties of Transact-SQL functions are determined automatically by SQL Server.
23 maj 2023 · The following scalar functions perform an operation on a string input value and return a string or numeric value: 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.
Learn how to use SQL Server functions to manipulate data, dates, strings, and windows. Find definitions, syntax, and examples of aggregate, date, string, system, and window functions.
Learn how to create, alter, and call user-defined functions in SQL Server. User-defined functions can be scalar or table-valued, and can contain one or more statements.
The list of SQL Server functions is sorted into the type of function based on categories such as string, conversion, advanced, numeric/mathematical, and date/time functions. These functions can be used in SQL statements or queries in SQL Server.
