MSSQL Query Blog

SQL Server

4 September 2023

by Yavuz Selim Kart · Published 4 September 2023

Supply a Valid Database Name in SQL Server. To See Available Databases, Use Sys.Databases Error

Hello everyone. In this article, Supply a valid database name in SQL Server. I will give information about To see available databases, use sys.databases. In SQL Server, you may encounter such an error in some cases. You can solve this error by using the code below. USE master; ALTER DATABASE...
SQL Server

12 August 2023

by Yavuz Selim Kart · Published 12 August 2023

Error 15023 in SQL Server

Hello everyone. In this article, I will provide information about error 15023 in SQL Server. When you restore from backup in SQL Server, when you restore to a different server, you may get such an error because the user record does not match. To fix the user and login mapping,...
SQL Server

11 August 2023

by Yavuz Selim Kart · Published 11 August 2023

Listing All Jobs Running in SQL Server

Hello everyone. In this article, I will provide information about listing all running jobs in SQL Server. In certain situations, you might want to list all the running jobs in SQL Server. You can easily perform this operation with the help of the code below: SELECT database_name, notify_level_email, name, enabled,...
SQL Server

22 June 2023

by Yavuz Selim Kart · Published 22 June 2023

Converting XML to Table in SQL Server

Hello everyone. In this article, I will try to give information about converting XML to table in SQL Server. In SQL Server you may want to convert XML to table in some cases. You can easily do this by revising the sample code below. DECLARE @TempTablo TABLE ( KullaniciId INT...
SQL Server

22 June 2023

by Yavuz Selim Kart · Published 22 June 2023

How to Clear Backup History and Job History in SQL Server?

Hello everyone. In this article, I will try to give information about how to clear backup history and job history in SQL Server. In SQL Server, in some cases, you may want to clear the backup history and job history. SQL Server keeps track of every backup and restore it...
SQL Server

19 June 2023

by Yavuz Selim Kart · Published 19 June 2023

Using CREATE or ALTER View in SQL Server

Hello everyone. In this article, I will try to give information about Using CREATE or ALTER View in SQL Server. There is a small but useful new feature for creating Views with SQL Server 2016 SP1. OR ALTER statement. If you add this statement to your code to create the...
SQL Server

18 June 2023

by Yavuz Selim Kart · Published 18 June 2023

Using the Geography Data Type in SQL Server

Hello everyone. In this article, I will try to give information about using the Geography data type in SQL Server. In SQL Server, in some cases, you may have to use the Geography data type. The data type that allows us to keep the coordinates in SQL Server is the...
SQL Server

18 June 2023

by Yavuz Selim Kart · Published 18 June 2023

Calculating Time Between Two Rows in SQL Server

Hello everyone. In this article, I will try to give information about calculating the time between two rows in SQL Server. In SQL Server you may want to calculate the time between two rows in some cases. You can easily do this by revising the sample code below. –Tablonun oluşturulması...
SQL Server

13 June 2023

by Yavuz Selim Kart · Published 13 June 2023

Listing Largest Tables and Indexes in Database in SQL Server

Hello everyone. In this article, I will try to give information about listing the largest tables and indexes in the database in SQL Server. In SQL Server, in some cases you may want to list the largest tables and Indexes in the database. You can easily do this using the...
Functions / SQL Server

8 June 2023

by Yavuz Selim Kart · Published 8 June 2023

Function to Print Words Side by Side in SQL Server

Hello everyone. In this article, I will try to give information about the function that prints the initials of words side by side in SQL Server. In SQL Server, in some cases, you may want to print the initials of the words of a given sentence side by side. You...

8 June 2023

Getting Second Word in Given Sentence in SQL Server

Hello everyone. In this article, I will try to give information about getting the second word in the sentence given in SQL Server. In SQL Server you may want to get the second word in the given sentence in some cases. You can easily do this using the code below....

SQL Server

8 June 2023

Converting VARCHAR Type Date to dd.mm.yyyy in SQL Server

Hello everyone. In this article, I will try to give information about converting VARCHAR type date as dd.mm.yyyy in SQL Server. In SQL Server, in some cases, you may want to convert the VARCHAR type date to dd.mm.yyyy. You can easily do this using the code below. DECLARE @tarih VARCHAR(30)...

SQL Server

1 June 2023

Procedure to Create Property from Tables and Views in SQL Server

Hello everyone. In this article, I will try to give information about the procedure that creates Property from Tables and Views in SQL Server. If you’re programming on the CSharp side, you need Properties. It can take a lot of time to create a table or view and then create...

SQL Server

28 May 2023

Viewing the Size of Log Files in SQL Server

Hello everyone, In this article, I will provide information about viewing the size of log files in SQL Server. In SQL Server we may want to view the size of log files in some cases. You can easily do this with the help of the code below. SELECT DB_NAME(mf.database_id) AS...

SQL Server

25 May 2023

Listing Tables by Creation Date in SQL Server

Hello everyone. In this article, I will try to give information about listing tables by creation date in SQL Server. In SQL Server, in some cases you may want to list tables by creation date. You can easily do this using the code below. SELECT name ,create_date FROM sys.tables ORDER...

SQL Server / Stored Procedures

25 May 2023

Customized PRINT Procedure in SQL Server

Hello everyone. In this article, I will try to give information about the customized PRINT procedure in SQL Server. In SQL Server, the PRINT statement prints up to 4000 characters. So what will you do if the content of the dynamic queries you write is longer than 4000 characters? In...

SQL Server / Stored Procedures

22 May 2023

Why You Shouldn’t Prefix “sp_” Before Your Stored Procedures in SQL Server?

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...

SQL Server

16 May 2023

Listing All Collations Supported in SQL Server

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...