SQL Server

This website provides a SQL server, SSRS, Power BI, Python, Azure basics and advanced tutorials for beginners and professionals .

You will find out a step-by-step walk through of the basics and advanced topics with practical and include numerous hands-on activities.

SQL Server Composite key

SQL Server Primary key is used to uniquely identify each rows in the table but sometimes more than one column are used to uniquely identify each rows in the table.

Print Prime numbers for any given n number in SQL Server

Print a prime numbers separted by comma for any given number .

For example, the prime number for 10 , wolud be 2,3,5,7 .

Here is the query:

Get the Students who scored higher than 80 Marks

Query to Get the Students who scored higher than 80 Marks ?

SQL Server Dynamic PIVOT

SQL server allows us to transform a row- level data into columnar data using SQL Pivot.

SQL CLUSTERED INDEX

SQL Server Clustered index

A clustered index defines the order in which data is physically stored in a table. A table can have only one clustered index because data rows can be only sorted in one order.

How to get all tables those are having a primary key

How to get all the tables in database those are having primary key constraints ?

SQL Server TEMPORAL TABLE

SQL Server Temporal tables (system-versioned tables) allow us to track data changes. It was introduced in SQL Server 2016.

It allows SQL Server to maintain and manage the history of the data in the table automatically, So we can get all information about the data that was stored at any specified time rather than just the data that is current.

SQL SERVER IF..ELSE

SQL Server IF..ELSE block is a control-of-flow that allows you to execute or skip a statement block based on a specified condition.

SYNTAX

IF Boolean_expression
{ sql_statement | statement_block }
[ ELSE { sql_statement | statement_block } ]

SYNTAX

IF Boolean_expression
{ sql_statement | statement_block }
[ ELSE { sql_statement | statement_block } ]

SQL Server WHILE

SQL Server WHILE loop sets a condition for the repeated execution of an SQL statement or statement block.

SQL Server UNPIVOT

SQL Server UNPIVOT allow us to transform columns of a table-valued expression into column values that is rotating columns into rows.

It performs a reverse operation of SQL Server PIVOT.

SYNTAX
SELECT …
FROM …
UNPIVOT (
FOR IN ( ) )

[ … ]

SQL Server FOR JSON Clause

SQL Server FOR JSON Clause is used to format query result to JSON format or export data from SQL Server as JSON format. It was introduced in SQL Server 2016 version.