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
8,464 total views, 2 views today
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
2,653 total views, 2 views today
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
1,426 total views
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
2,988 total views, 4 views today
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.
1,391 total views
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.
1,221 total views, 1 views today
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.
1,653 total views
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.
1,712 total views, 3 views today
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.
2,209 total views
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.
8,836 total views, 7 views today
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.
2,487 total views, 7 views today
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.
1,732 total views, 2 views today
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.
1,699 total views, 2 views today
SQL Server NEWSEQUENTIALID()
SQL Server NEWSEQUENTIALID() function is used to generate incremental unique values of type uniqueidentifier.
3,884 total views, 5 views today
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 .
1,441 total views
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.
1,077 total views, 1 views today
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.
1,045 total views, 5 views today
SQL Server NEWID()
SQL Server NEWID() function is a system function that is used to generate a unique value of type uniqueidentifier.
9,126 total views, 9 views today
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.
1,390 total views, 3 views today
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.
2,156 total views