MSSQL and TSQL Programming and TSQL Examples
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...
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,...
Hello everyone, In this article, I will provide information about creating a random password in SQL Server. In SQL Server, we may want to create a random password in some cases. You can easily do this with the help of the code below. SELECT ( SELECT ” + Psswrd FROM...
Hello everyone, In this article, I will give information about the prime number checking procedure in SQL Server. You can constantly improve yourself by making such examples in SQL Server. You can easily do this with the help of the code below. CREATE PROC IsNumberPrime @Number INT AS DECLARE @Counter...
Hello everyone, In this article, I will provide information about listing users and their roles in SQL Server. In SQL Server, in some cases, we may want to list users and their roles. You can easily do this with the help of the code below. SELECT spU.name, MAX( CASE WHEN...
Hello everyone, In this article, I will give information about seeing server property information with the SERVERPROPERTY function in SQL Server. In SQL Server, in some cases, we may want to obtain information about the properties of the server. You can easily do this with the help of the code...
Hello everyone, In this article, I will give information about listing the files in the hard disk in SQL Server. In SQL Server, in some cases, it may be necessary to list the files in the hard disk. By using the code below, you can perform the listing of the...
Hello everyone, In this article, I will give information about finding the first and last day of the month with the EOMONTH function in SQL Server. In SQL Server you may need the first and last days of a month in some cases. You can easily do this with the...