Stored Procedure to check user login #sql #stored-procedure

Stored Procedure to check user login.md

###Stored Procedure to check user login

Validating (Check) Username and Password from database using stored procedure.

CREATE PROCEDURE [dbo].[usp_CheckLogin] 
	-- ADD THE PARAMETERS FOR THE STORED PROCEDURE
	@UserID		int,
	@Password	nvarchar(50),
	@Result		int = '0' 
AS
BEGIN
	-- SET NOCOUNT ON ADDED TO PREVENT EXTRA RESULT SETS FROM
	-- INTERFERING WITH SELECT STATEMENTS
	SET NOCOUNT ON;

    -- SELECT STATEMENTS FOR PROCEDURE HERE
	IF EXISTS (SELECT * FROM tblAuthentication WHERE UserID = @UserID AND Password = @Password)
	SET @Result = 1
	ELSE
	SET @Result = 0
	PRINT @Result
END