MSSQL and TSQL Programming and TSQL Examples
SQL Server related articles and SQL Server related code examples and TSQL Codes
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...
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,...
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,...
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...
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...
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...
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...
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ı...