SP For Create and update

CREATE PROCEDURE [dbo].[USP_AddCategory]  

    @ID INT,  

 @Category_ID nvarchar(50) = NULL,  

 @Category_Desc nvarchar(255) = NULL,  

 @UpdatedOn datetime = NULL,  

 @UpdatedBy nvarchar(150) = NULL,  

 @IsActive bit = NULL  

   

AS  

BEGIN  

 SET NOCOUNT ON;  

 BEGIN TRANSACTION [InsertCategoryDetails]  

 BEGIN TRY  

  --DECLARE @ID INT  

  

  IF NOT EXISTS (SELECT * FROM tbl_Category WHERE Category_ID = @Category_ID)  

  BEGIN  

   Insert Into tbl_Category (  

    Category_ID, Category_Desc, UpdatedOn, UpdatedBy, IsActive  

    )  

   Values (  

     @Category_ID, @Category_Desc, IsNull(@UpdatedOn,GetDate()), @UpdatedBy, IsNull(@IsActive,1)  

   )  

   SET @ID = (SELECT SCOPE_IDENTITY())  

   SELECT @ID AS ID, 'true' AS [Status], 'Category created successful' as [Message]   

  END     

  ELSE  

   SELECT '0' AS ID, 'false' AS [Status], 'The category is already existed' as [Message]   

  

 COMMIT TRANSACTION [InsertCategoryDetails]  

 END TRY  

    BEGIN CATCH  

 ROLLBACK TRANSACTION [InsertCategoryDetails]  

  SELECT '0' AS ID, 'false' AS [Status], 'Failed to save' as [Message]   

  INSERT INTO tbl_Errors(ErrorNumber,ErrorState,ErrorSeverity,ErrorLine,ErrorProcedure,ErrorMessage,ErrorDateTime )  

  SELECT    

   ERROR_NUMBER() AS ErrorNumber, ERROR_STATE() AS ErrorState, ERROR_SEVERITY() AS ErrorSeverity   

   ,ERROR_LINE() AS ErrorLine, ERROR_PROCEDURE() AS ErrorProcedure, ERROR_MESSAGE() AS ErrorMessage  

   ,GETDATE()  

    END CATCH  

END