Loading

stored procedure in sqlserver

stored procedure in sqlserver

Mahesh Babu

8y1.1kLearn iOS Programming

How to check the condition

this is my sp

how to check the id is null in the sp

alter PROCEDURE Check_Exist

(

@Id INT,

@balance money

)

AS

BEGIN

If @Id is null

IF NOT EXISTS (SELECT AccountId FROM Account WHERE [AccountId]=@Id)

BEGIN

INSERT INTO Account VALUES(@Id,@balance)

PRINT 'New Record Insert Successfuly'

END

ELSE

BEGIN

PRINT 'Id All Ready Exist'

END

END

please help me this

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Pravat Kumar8y ago
Accepted answer
Hello Mahesh,

Please check it once.

ALTER PROCEDURE Check_Exist (
@Id INT = NULL
,@balance MONEY
)
AS
BEGIN
IF ISNULL(@Id,0)!=0
IF NOT EXISTS (
SELECT AccountId
FROM Account
WHERE [AccountId] = @Id
)
BEGIN
INSERT INTO Account
VALUES (
@Id
,@balance
)
PRINT 'New Record Insert Successfuly'
END
ELSE
BEGIN
PRINT 'Id All Ready Exist'
END
END
Raja T8y ago
Hi Mahesh,Please check below

ALTER PROCEDURE CHECK_EXIST
(
   @ID INT,
   @BALANCE MONEY
)
AS
BEGIN
   IF (@ID IS NOT NULL AND @ID !=0)
   BEGIN
         IF NOT EXISTS (SELECT ACCOUNTID FROM ACCOUNT WHERE                                                                                                       [ACCOUNTID]=@ID)
         BEGIN
            INSERT INTO ACCOUNT VALUES(@ID,@BALANCE)
            PRINT 'NEW RECORD INSERT SUCCESSFULY'
         END
   END
   ELSE
   BEGIN
      PRINT 'ID ALL READY EXIST'
   END
END
Sanwar Ranwa8y ago
Hello

Please check these links

https://dba.stackexchange.com/questions/74461/stored-procedure-null-parameter-within-where-clause

https://www.codeproject.com/Questions/617986/how-to-handle-null-value-or-empty-string-in-Stored

https://forums.asp.net/t/1445976.aspx?Stored+procedure+to+check+if+record+exists

https://stackoverflow.com/questions/12264602/how-do-check-if-a-parameter-is-empty-or-null-in-sql-server-stored-procedure-in-i

https://stackoverflow.com/questions/334108/how-do-i-check-if-a-sql-server-string-is-null-or-empty