SQL Random Number
SQL RAND function is a mathematical function which returns a pseudo-random float value from 0 through 1, exclusive or a random value within any range.… Read More »SQL Random Number
Home » SQL SERVER »
SQL Functions
SQL Server Function includes Aggregate functions, Conversion functions, Analytics functions, Date functions, Logical Functions, String funcitons, and System functions
SQL QUOTENAME Function
SQL QUOTENAME function is a string function which returns a Unicode string with the delimiters added to make the input string a valid SQL Server… Read More »SQL QUOTENAME Function
SQL ROUND Function
The SQL ROUND function is a SQL Mathematical Function which is used to round a number to a specified length or precision. It returns a… Read More »SQL ROUND Function
SQL PARSE Function
The SQL PARSE function is a SQL Conversions Function that is used to convert the string data to the requested data type and returns the… Read More »SQL PARSE Function
SQL Server FLOOR Function
SQL Server FLOOR Function is a mathematical function that returns the largest integer value that is less than or equal to a number.
SQL Server CEILING Function
SQL Server CEILING Function is a mathematical function that returns the smallest integer value that is greater than or equal to a number.
SQL Server LAST_VALUE function
SQL Server LAST_VALUE function is a Analytic function which returns the Last value in an ordered set of values.
SQL Server FIRST_VALUE function
SQL Server FIRST_VALUE function is a Analytic function which returns the first value in an ordered set of values.
SQL Server PATINDEX
SQL Server PATINDEX function is a string function that returns the starting position of the first occurrence of a pattern in a specified expression.
SQL Server STRING_AGG Function
SQL Server STRING_AGG() Function is string function which concatenates values for any given string expressions and separate them a specified separator.
It does not add the separator at the end of the result string.
String expression values are implicitly converted to string types and then concatenated.
SQL Server Format Function
The SQL Format function is a SQL Server string function which is used to format the specified value in the given format such as to format the date/time values and number values.
SQL Server Lag Function
SQL Server LAG() function is a Analytics Functions that provides access to a row at a given physical offset that comes before the current row.
SQL Server Lead Function
SQL Server LEAD() function is a Analytics function that provides access to a row at a specified physical offset which follows the current row.
Basically, LEAD() function provides access to a row at a given physical offset that follows the current row.
SQL Server NEWSEQUENTIALID()
SQL Server NEWSEQUENTIALID() function is used to generate incremental unique values of type uniqueidentifier.
SQL SERVER REVERSE
SQL Server REVERSE Function is a string function that returns the reverse order of a string value. It returns a value of type varchar or nvarchar .
SQL SERVER ISNULL
SQL Server ISNULL() Function is a system function that returns the specified value if the expression is NULL else it returns the expression.
SQL Server @@ERROR
SQL Server @@ERROR is a global variable that returns an error number if the last statement encountered an error but we have to trace it within just after the next line where the actual error occurred, otherwise, it will reset to 0.
SQL Server NEWID()
SQL Server NEWID() function is a system function that is used to generate a unique value of type uniqueidentifier.
SQL SERVER @@IDENTITY
SQL Server @@IDENTITY function is a system function that is used to get the last IDENTITY value generated for any table with an identity column under the current session, regardless of the scope of the T-SQL statement that generated the value.
SQL Server CONCAT_WS Function
SQL Server CONCAT_WS() function is a string function that is used concatenates two or more strings together with a separator.
It separates those concatenated string values with the delimiter specified in the first function parameter.