MSSQL Query

MSSQL and TSQL Programming and TSQL Examples

MSSQL Query Blog

SQL Server

Generating Random Password in SQL Server

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

SQL Server / Stored Procedures

Prime Number Checking Procedure in SQL Server

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

SQL Server

Listing Users and Their Roles in SQL Server

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

SQL Server / Stored Procedures

Listing Files in Hard Disk in SQL Server

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

SQL Server

Performing an Update by Checking for Data in SQL Server

Hello everyone, In this article, I will provide information about performing the update process by checking if there is data in SQL Server. In SQL Server, in some cases, it is possible to check whether the data exists and to perform the update process. You can easily do this with...

Don`t copy text!