SQL Advance Tutorial

SQL Server Recursive CTE

A Recursive CTE (Common Table Expression) is a CTE that references itself. In doing so, the initial CTE is repeatedly executed, returning subsets of data, until it returns the complete result set.

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

How to create a custom shortcuts in SQL Server

How to create a custom shortcuts for stored procedures in SQL Server ?

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

How to Retrieve data in XML Format in SQL SERVER

How to Retrieve data in XML Format in SQL SERVER ?

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 Unique Key Constraint

A unique key constraint is a set of one or more than one columns of a table that uniquely identify a record in a database table.

SQL Primary Key constraint

A PRIMARY KEY constraint uniquely identifies each record in a table .

SQL FOREIGN KEY Constraint

A foreign key is a key used to link two tables together. This is sometimes also called as a referencing key , usually a primary key table is considered as a parent table while a foreign key table is considered as a child table .