Learn SQL Step by Step

Identify blocked processes or long nunning query in SQL Server

Blocking occurs when a process hold a lock and other process has to wait till the first process completes.

SQL Server CUBE

CUBE operator is used to calculate subtotals and grand total for all combinations of grouping columns specified in the GROUP BY clause.

SQL Server GROUPING SETS

SQL GROUPING SETS allows computing multiple GROUP BY clauses in a single statement. The results of GROUPING SETS are the equivalent of UNION ALL of the specified groups.

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.

How to Retrieve data in XML Format in SQL SERVER

How to Retrieve data in XML Format in 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.

Delete duplicate rows from a table in SQL Server

how to delete duplicates records from a table in sql server ?.

SQL Server CTE

SQL Server CTE (Common Table Expression) is temporary result set that is used to reference within another SELECT, INSERT, UPDATE, or DELETE statement.

SQL Server Sequence

A Sequence objects are used to sequentially generate numeric values that can be in ascending or descending order at a defined interval and may cycle if requested.

SQL SERVER Interview Q & A QUIZ on SUBSTRING()

SQL interview question and answer on Substring function

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 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.

SQL SERVER EXCEPT

The SQL EXCEPT clause is used to combine two SELECT statements and returns rows from the first SELECT statement that are not returned by the second SELECT statement.

SQL SERVER INTERSECT

The SQL INTERSECT clause is used to combine two SELECT statements, but returns rows only from the first SELECT statement that are identical to a row in the second SELECT statement.