Breaking News: Grepper is joining You.com. Read the official announcement!

Stored Procedure to check two conditions for registering user

Dr. Vivek Koppikar answered on January 20, 2023 Popularity 1/10 Helpfulness 1/10

answer Stored Procedure to check two conditions for registering user

Stored Procedure to check two conditions for registering user

Comment

USE [admin_showcaseusers]
GO
/****** Object:  StoredProcedure [dbo].[spRegisterUser]    Script Date: 20-01-2023 09:46:29 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROC [dbo].[spRegisterUser] 
@UserName NVARCHAR(100)
,@Password NVARCHAR(200)
,@Pback NVARCHAR(200)
,@MobileNumber NVARCHAR(200)
AS
BEGIN
DECLARE @Count INT
DECLARE @Count1 INT
DECLARE @ReturnCode INT

SELECT @Count = COUNT(UserName)
FROM tblUsers
WHERE UserName = @UserName

SELECT @Count1 = COUNT(MobileNumber)
FROM tblUsers
WHERE MobileNumber = @MobileNumber

IF @Count > 0 
BEGIN
SET @ReturnCode = - 1
END


ELSE IF @Count1 >0
BEGIN
SET @ReturnCode = - 2
END

ELSE
BEGIN
SET @ReturnCode = 1

INSERT INTO tblUsers
VALUES (
@UserName
,@Password
,@Pback
,@MobileNumber	
)
END

SELECT @ReturnCode AS ReturnValue
END

Popularity 1/10 Helpfulness 1/10 Language csharp

Source: Grepper

Tags: c# procedure registering

Link to this answer
Share Copy Link

Contributed on Jan 20 2023

Dr. Vivek Koppikar

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

Stored Procedure to check two conditions for registering user

Contents

More Related Answers

Stored Procedure to check two conditions for registering user

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.