IF((SELECT COUNT(*) FROM s_Users WHERE username=@username and password=@password)>0) -- login
IF EXISTS(SELECT 1 FROM s_Users WHERE username=@Username AND password=@Password) BEGIN -- ACCEPT LOGIN END ELSE -- AUTHENTICATION FAILURE
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)