CREATE PROCEDURE Login
(
@Email_ID NVARCHAR (50),
@Pass NVARCHAR (50)
)
AS
BEGIN
SET NOCOUNT ON
SELECT *
FROM Registration
WHERE Email_ID = @Email_ID
AND pass = @pass COLLATE SQL_Latin1_General_CP1_CS_AS
END
Then just replace SELECT * with whatever fields you need to have come back.