MSSQL and TSQL Programming and TSQL Examples
Hello everyone. In this article, I will try to give information about why you should not add “sp_” prefix in front of your Stored Procedures in SQL Server. Most people tend to prefix “sp_” to the name of the Stored Procedure when creating a Stored Procedure in SQL Server. There...
Hello everyone. In this article, I will try to give information about listing all collations supported in SQL Server. In SQL Server you may want to list all supported collations in some cases. You can easily do this using the query below. SELECT name, COLLATIONPROPERTY(name, ‘CodePage’) AS Code_Page, description FROM...
Hello everyone. In this article, I will try to give information about changing the collation of all columns in SQL Server. In SQL Server, in some cases, when you change the Collation of the database, the Collation may not change in the columns and you may want to change the...
Hello everyone. In this article, I will give information about all DROP IF EXISTS usages in SQL Server. In SQL Server you may need to use DROP IF EXISTS in some cases. You can easily do this using the code below. Note: The commands below work on SQL Server 2016...
Hello everyone. In this article, I will give information about cleaning left and right spaces in SQL Server. In SQL Server you may want to clear left and right spaces in some cases. You can easily do this using the code below. You can use the code below to clear...
Hello everyone. In this article, we will analyze ½, that is, a part 2, expression in SQL Server mathematically. In SQL Server, you may come across such questions in interviews or while writing a query. This is a small question. However, it’s also an interesting question. Many people immediately answer...
Hello everyone. In this article, I will try to give information about creating a Recursive Menu in SQL Server. You can create simple or advanced nested menus in SQL Server. First, let’s create a table called “Menu”. CREATE TABLE Menu ( MenuID INT PRIMARY KEY ,MenuName NVARCHAR(50) ,ParentMenuID INT NULL...
Hello everyone. In this article, I will give information about formatting an IBAN number in SQL Server. In SQL Server, in some cases, you may want to format the IBAN number. You can easily do this using the code below. DECLARE @iban VARCHAR(50) = ‘TR320010009999901234567890’; SELECT CONCAT(SUBSTRING(@iban, 1, 2), ‘...