Category: SQL Server

SQL Server related articles and SQL Server related code examples and TSQL Codes

Error 15023 in SQL Server

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

Listing All Jobs Running in SQL Server

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

Converting XML to Table in SQL Server

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

Using CREATE or ALTER View in SQL Server

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

Using the Geography Data Type in SQL Server

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

Calculating Time Between Two Rows in SQL Server

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

Don`t copy text!