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.
Home » SQL SERVER » SQL Basics »
SQL Basics
SQL Server Basics Concepts includes SQL Database Creation, Tables, SQL DML , and DDL Commands, Joins, Key Constraints, Functions and so on..
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.
SQL STRING_SPLIT function
SQL Server STRING_SPLIT function is used to split a string into a table that consists of rows of substrings based on a specified separator. This function was introduced in SQL Server 2016 .
STRING_SPLIT requires the compatibility level to be at least 130. When the level is less than 130, SQL Server is unable to find the STRING_SPLIT function.
SQL Server ISNUMERIC Function
SQL Server ISNUMERIC( ) function is System Functions which is used to check if the expression is valid numeric type or not.
SQL Server Computed Columns
A computed column is a virtual column which is used to add a new column to a table with the value derived from the values of other columns in the same table.
Computed column is not physically stored in the table, unless column is marked PERSISTED and it is persisted only if its expression is deterministic.
SQL Server CHECK Constraint
SQL Server Check Constraints restrict the values that are accepted by one or more columns.
SQL Server CHOOSE Function
SQL Server Tutorials By Pradeep Raturi : SQL Server CHOOSE Functions is the logical function that returns the item at the specified index from a list of values in SQL Server.
SQL Server IIF Function
SQL Server Tutorials By Pradeep Raturi : SQL Server IIF function is the logical function that returns one of two parts, depending on the evaluation of an expression.
Temporary table / temp table in SQL Server
Temporary or Temp tables are tables that exist temporarily on the SQL Server.
SQL SERVER TRY_CAST()
SQL Server TRY_CAST() Function is a conversion functions that is used to cast a value to a specified data type.
SQL Server DENSE_RANK()
The DENSE_RANK() is a Ranking function that is used to assign ranks to rows in partitions with no gaps in the ranking values.
SQL RANK()
The RANK() function is a window function that is used to assign a rank to each row in the partition of a result set.
SQL Server ROW_NUMBER()
SQL Row_Number() is a ranking function/window function that is used to assign a sequential integer to each row within a partition of a result set. The row number starts with one for the first row in each partition.