Microsoft SQL Server Tutorials
In this SQL Server tutorial, you will learn about SQL Server find string in a string. While analysing the data, I needed to find the specific existence of the strings within the data containing strings. Actually, I needed to find the specific pattern of strings, so for that, I used the CHARINDEX() function. Apart from … Read more
In this Python tutorial, you will learn about SQL Server to convert XML to string. As you already know, you can’t use the XML data as a string if it is in the XML format. I mean, you can’t use it in your app. To use the XML data, you need to convert it into … Read more
In this SQL Server tutorial, you will learn about SQL Server and check if the column Exists. As a database developer, you must know how to check if a column exists in the table, so I have explained several approaches to checking column existence here. Let’s start, SQL Server Check If Column Exists You can … Read more
In this SQL Server tutorial, I will show you how to drop a table if it exists in SQL Server. As a database developer, whenever the business logic changes, sometimes table objects become unnecessary, so removing these unnecessary objects is very important. In this tutorial, I have explained how to drop one of the objects, … Read more
In this SQL Server tutorial, I will explain the SQL Server drop column with constraint. Sometimes, you need to drop a column when it is no longer needed, but if any constraint depends on the column you want to drop, you may not be able to drop that column, and it will show an error … Read more
In this SQL Server tutorial, I will show you how to create a view in SQL Server Management Studio. You may be familiar with a query or the command that allows you to create a view but want to extend your knowledge to create a view using the SSMS, so I have explained step by … Read more
In this SQL Server tutorial, I will explain the SQL Server change column to NOT NULL. I created an e-commerce website that was running smoothly, but one day, I realized that the column stock could store null values. I needed to fix this issue because these columns must not contain null values. So, I used … Read more
In this SQL Server tutorial, you will learn how to rename column name in SQL Server. Sometimes, a situation arises due to changes in the business logic where you will have to change the column’s name in the table. Considering that situation, I have explained two methods in this tutorial for renaming a column in … Read more
In this SQL Server tutorial, I will show you how to create an identity column in SQL Server. As a beginner, you must know how to insert unique records in a table and avoid duplicating records from inserting. So, here, I will explain a clause called IDENTITY that helps insert unique records into a table … Read more
In this SQL Server tutorial, You will learn about SQL Server split string into rows. As a database developer or data engineer, sometimes, you need to split a string into rows while processing data. You will understand two methods to split a string into rows; in the first method, you will use the STRING_SPLIT() function, … Read more