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
Home » SQL Tutorials »
SQL 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.
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
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
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 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
Column Level Encryption Decryption using Symmetric Keys
SQL Server allows several options to protect sensitive data, and one of them is specifying a column level encryption. Using this option you can encrypt… Read More »Column Level Encryption Decryption using Symmetric Keys
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_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