How to check the conditions in storedprocedure

Question

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

Suraj Kumar · Answer

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 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 Ranwa · Answer

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

How to check the conditions in storedprocedure

Answers (2)