PARSENAME Function
PARSENAME function is a SQL Server Metadata function which returns the specified part of an object name. The parts of an object that can be… Read More »PARSENAME Function
Home » SQL Server Tutorials »
SQL Server Tutorials
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 SELECT TOP
SQL SELECT TOP statement is used to retrieve records from tables and limit the number of rows or percentage of rows returned based on a… Read More »SQL SELECT TOP
How to get Ordinal Number in SQL
If any number that is written like as 1st, 2nd, 3rd and so on.. is called an ordinal number, and it is read as 1st(… Read More »How to get Ordinal Number in SQL
Check if column Exists or not in SQL Server Table
There are various in-built system catalog views, or metadata functions that you can use to check the existence of column in SQL Server tables. To… Read More »Check if column Exists or not in SQL Server Table
Print Christmas tree in SQL Server
Lets see how to print a Xmas or Christmas Tree in SQL Server. The best way of implementing a Xmas tree pattern you can use a… Read More »Print Christmas tree in SQL Server
SQL Code Snippets
SQL code snippet is a template which contains the basic structure of a Transact-SQL statement or block, so that you can quickly write queries without… Read More »SQL Code Snippets
DROP IF EXISTS
SQL Server 2016 has released an optional IF EXISTS clause with DROP statement that can be used as DROP IF EXISTS. DROP IF EXITS verify… Read More »DROP IF EXISTS
SQL Server Saving Changes is not permitted error
You might have faced an error as shown below, when you make some changes in table from design mode in SQL server management studio (SSMS).… Read More »SQL Server Saving Changes is not permitted error
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
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 a savepoint is specified, 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
How to Read SQL Server error logs using the xp_readerrorlog
Xp_readerrorlog is a SQL Server extend stored procedure allows you read the contents of the SQL Server error log files. It allows you to read… Read More »How to Read SQL Server error logs using the xp_readerrorlog
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_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