Security PWDCOMPARE SQL function

1. Usage of PWDCOMPARE

SQL Server Query 1

            
 SELECT PWDCOMPARE('password', PWDENCRYPT('password'))   

            
        

Create SQL query with SqlQueryBuilder 1

            
 var (sql1, parameters1) = new SqlQueryBuilder()  

     .Select()  

     .Column(new PWDCOMPARE("password", new PWDENCRYPT("password")), "IsMatch")  

     .Build();  

            
        

Query build by SqlQueryBuilder 1

            
SELECT PWDCOMPARE(@pMAIN_2507192049582223260, PWDENCRYPT(@pMAIN_2507192049582223261)) AS IsMatch;


            
        

Parameters (If used)

Query Results 1: