MSSQL Query

MSSQL and TSQL Programming and TSQL Examples

MSSQL Query Blog

SQL Server

Listing Failed Jobs in SQL Server

Hello everyone, In this article, I will give information about listing the failed jobs in SQL Server. In some cases, we may want to list the jobs that are not running successfully in SQL Server. You can easily do this with the help of the code below. SELECT @@SERVERNAME ServerName,...

SQL Server

Listing All Indexes in Database in SQL Server

Hello everyone, In this article, I will give information about listing all the indexes in the database in SQL Server. In SQL Server, in some cases, we may want all index values in the database to be listed. You can easily do this with the help of the code below....

SQL Server

Extracting Filename from a File Path in SQL Server

Hello everyone, In this article, I will provide information about pulling a filename from a file path in SQL Server. In SQL Server, in some cases, we may want to extract the file name from the file path information. You can easily do this with the help of the code...

SQL Server

Function to Clear Trailing in a Post in SQL Server

Hello everyone, In this article, I will provide information about the function that clears the trailing part in an article in SQL Server. In SQL Server, in some cases, we may want to clear the trailing part of an article. You can easily do this with the help of the...

Functions / SQL Server

Function Controlling Weekdays in SQL Server

Hello everyone, In this article, I will give information about the function that controls weekdays in SQL Server. In SQL Server we may want to check the weekdays in some cases. You can easily do this with the help of the function below. CREATE FUNCTION CheckYourWeekdays ( @Date DATE )...

SQL Server

Separating Numbers into Groups of Three in SQL Server

Hello everyone, In this article, I will give information about dividing numbers into groups of three in SQL Server. In SQL Server, in some cases we may want to separate our numbers into triple digits to make them more readable. You can easily do this with the help of the...

SQL Server

Listing All Running Jobs in SQL Server

Hello everyone, In this article, I will give information about listing all the jobs running in SQL Server. In some cases we may want to list all running jobs in SQL Server. You can easily do this with the help of the code below. SELECT database_name, notify_level_email, name, enabled, description,...

Don`t copy text!