MSSQL Query

MSSQL and TSQL Programming and TSQL Examples

MSSQL Query Blog

SQL Server

Getting File’s Directory and Parent Directory in SQL Server

Hello to everyone, In this article, I will try to give information about getting the directory and parent directory of the file in SQL Server. In SQL Server, in some cases you may want to get the directory and parent directory of the file. You can easily do this using...

Functions / SQL Server

Function to Fix Turkish Character Problem in SQL Server

Hello to everyone, In this article, I will give information about the function that fixes the Turkish character problem in SQL Server. First of all, there are other solutions to this process. Please also research these methods before using functions. You may experience Turkish character problems in SQL Server in...

Functions / SQL Server

Phone Formatting Function in SQL Server

Hello to everyone, In this article, I will provide information about the phone formatting function in SQL Server. In SQL Server, in some cases, you may want to format and display phone numbers in order to make them more readable. You can easily do this by using the function below....

SQL Server

Extracting Schema List of All Databases in SQL Server

Hello to everyone, In this article, I will provide information about extracting the Schema list of all databases in SQL Server. In SQL Server, in some cases, you may want to extract the Schema list of all databases. You can easily do this using the code below. DECLARE @SQL NVARCHAR(MAX);...

SQL Server

Navigating Table Without Using Cursor in SQL Server

Hello to everyone, In this article, I will give information about navigating the table without using Cursor in SQL Server. In most cases, most people prefer to use Cursor to navigate the table in SQL Server, but it is a very costly operation. Of course, Cursor is used where Cursor...

Don`t copy text!