Loading

How to check the conditions in storedprocedure

How to check the conditions in storedprocedure

Chintapalli Yeswanth

8y602Learn iOS Programming

How to check the conditions in

storedprocedure

i need to check the empid

if empid exits then print message like exits

if not then save into db

if empid null then print msg

after i need to check the year is madatoryfield

if year exits print msg

same like above

please help me this

Thanks

2 Replies

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

Suraj Kumar8y ago
Hello,
You can check in stored procedure as it is below

CREATE PROCEDURE [dbo].[UspAddEditStudent]
@Id int,
@Emp_ID int,
@Emp_Name varchar(50)
AS
BEGIN
IF @Id <= 0
BEGIN
   IF NOT EXISTS(SELECT 1 FROM EmpMaster WHERE Emp_ID = @Emp_ID)
   BEGIN
      INSERT INTO EmpMaster (Emp_ID, Emp_Name)
      VALUES(@Emp_ID, @Emp_Name)


      SELECT 'Employee Created Successfully.'
   END
ELSE
   BEGIN
      SELECT 'Employee Already Exist!'
   END
END
ELSE IF @Id > 0
   BEGIN
      IF NOT EXISTS(SELECT 1 FROM EmpMaster WHERE Emp_ID = @Emp_ID AND Id <>       @Id)
      BEGIN
         UPDATE EmpMaster
         SET Emp_ID = @Emp_ID,
         Emp_Name = @Emp_Name
         WHERE Id = @Id


         SELECT 'Employee Updated Successfully.'
END
ELSE
      BEGIN
         SELECT 'Employee Already Exist!'
      END
END
END
Sanwar Ranwa8y ago
Hello

Please check these links

https://www.mindstick.com/blog/354/checking-if-else-condition-in-stored-procedure-sql-server
https://stackoverflow.com/questions/18532663/if-else-in-stored-procedure-sql-server