Home ยป SQL Tutorial

SQL Tutorial

This website provides a SQL Tutorial, 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.

Script table in SQL Server

You can script a table from database using a SQL Server Management Studio. SQL Server Management allows you to script out tables from database using… Read More »Script table in SQL Server

Generate Database Scripts With Data in SQL Server

You can generate a database scripts including the schema and the data by using the Generate Scripts option available in SQL Server Management Studio (SSMS),… Read More »Generate Database Scripts With Data in SQL Server

Table Value Constructor

Table Value Constructor (TVC) allows to group multiple rows of data in a single DML statement. It can be used as a part of either… Read More »Table Value Constructor

Change the column name and data type of result set of stored procedure

SQL Server 2012 has released a new feature WITH RESULT SETS, whichย allows column names and their data types to be changed in the result set… Read More »Change the column name and data type of result set of stored procedure

How to get TOP N records for each category

Selecting a top n records for each category from any table, can be done easily using row_number function which generates a sequential integer to each… Read More »How to get TOP N records for each category

IDENT_CURRENT Function

The IDENT_CURRENT function returns the last IDENTITY value generated for any specific table or view on an identity column in any session and any scope.… Read More »IDENT_CURRENT Function

SQL Vulnerability Assessment

SQL Vulnerability Assessment (VA) is an easy to use tool that you can use to identify, track, and remediate potential database vulnerabilities. The VA service… Read More »SQL Vulnerability Assessment

SQL ROLLBACK Transactions

SQL ROLLBACK transaction statement rolls back an explicit or implicit transaction to the beginning of the transaction. If savepoint is specified then it rolls back… Read More »SQL ROLLBACK Transactions

Separate numbers, letters and special characters from string

How to find and separate the numbers, letters and special characters from string? Suppose you a column in table which contains a mix words which… Read More »Separate numbers, letters and special characters from string

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

SQL JSON_VALUE Function

JSON_VALUE is a JSON function which is used to extracts scalar value from JSON string. It returns a single text value of type nvarchar. It… Read More »SQL JSON_VALUE Function

SQL JSON_QUERY Function

SQL JSON_QUERY is a JSON function which extracts an object or an array from a JSON string. JSON_QUERY function introduced in SQL Server 2016. You… Read More »SQL JSON_QUERY Function

SQL JSON_MODIFY Function

The JSON_MODIFY is a JSON functions that allows you to update the value of a property in a JSON string. It introduced in SQL Server… Read More »SQL JSON_MODIFY Function

SQL Correlated Subquery

A correlated subquery is a subquery that uses the values of the outer query and it is evaluated for each row processed by the outer… Read More »SQL Correlated Subquery

SQL sp_helptext

SQL sp_helptext is a SQL Server System stored procedure that displays the the definition of any SQL Server objects. You can see the definition of… Read More »SQL sp_helptext

How to Encrypt a Stored Procedure in SQL Server

Encrypting a SQL Server Stored Procedure If you have any complex business logic that you want to keep secure and hide from end user due… Read More »How to Encrypt a Stored Procedure in SQL Server

SQL Over Clause

SQL OVER clause allows the use of aggregation without using a group by clause. OVER caluse aggregate rows across groups of another field using the… Read More »SQL Over Clause

SQL Server @@Servicename

SQL @@servicename is SQL Server configuration function which returns the name of the registry key under which SQL Server is running. This function does not… Read More »SQL Server @@Servicename