Data Operation in SQL

USE [LeadManagement] GO
/****** Object: StoredProcedure [dbo].[Category_InsertUpdate] Script Date: 05/16/2015 06:11:37 ******/
SET
ANSI_NULLS ON GO
SET
QUOTED_IDENTIFIER ON GO -- =============================================
-- Author: <Chirag Patel>
-- Create date: <18 Dec 2013>
  -- Description:  <Insert/ Update Lead Category>
  -- =============================================
  ALTER PROCEDURE [dbo].[Category_InsertUpdate] @id int output,
  @name nvarchar(50) AS BEGIN DECLARE @duplicate int IF(
    @id = 0
    OR @id IS NULL
  ) BEGIN
SELECT
  @duplicate = COUNT(ID)
FROM
  CATEGORY
WHERE
  NAME = @name
  AND IS_DELETED = 0 IF(@duplicate = 0) BEGIN INSERT INTO CATEGORY
VALUES
  (@name, 0)
SELECT
  @id = CAST(
    SCOPE_IDENTITY() AS bigint
  ) END ELSE
SELECT
  @id = CONVERT(bigint, '0') END ELSE BEGIN
SELECT
  @duplicate = COUNT(ID)
FROM
  CATEGORY
WHERE
  NAME = @name
  AND ID <> @id
  AND IS_DELETED = 0 IF(@duplicate = 0) BEGIN
UPDATE
  CATEGORY
SET
  NAME = @name
WHERE
  ID = @id
SELECT
  @id as ID END ELSE
SELECT
  @id = CONVERT(bigint, '0') END END USE [LeadManagement] GO
  /****** Object: StoredProcedure [dbo].[Category_GetAll] Script Date: 05/16/2015 06:18:06 ******/
SET
  ANSI_NULLS ON GO
SET
  QUOTED_IDENTIFIER ON GO -- =============================================
  -- Author:  <Chirag Patel>
  -- Create date: <8 Nov 2013>
  -- Description:  <Get all categories>
  -- =============================================
  ALTER PROCEDURE [dbo].[Category_GetAll] @id int AS BEGIN IF @id > 0
SELECT
  ID,
  NAME
FROM
  CATEGORY
WHERE
  ID = @id
  and IS_DELETED = 0
ORDER BY
  NAME ELSE
SELECT
  ID,
  NAME
FROM
  CATEGORY
WHERE
  IS_DELETED = 0
ORDER BY
  NAME END USE [LeadManagement] GO
  /****** Object: StoredProcedure [dbo].[Category_Delete] Script Date: 05/16/2015 06:18:22 ******/
SET
  ANSI_NULLS ON GO
SET
  QUOTED_IDENTIFIER ON GO -- =============================================
  -- Author:  <Chirag Patel>
  -- Create date: <18 Dec 2013>
  -- Description:  <Delete Lead Category>
  -- =============================================
  ALTER PROCEDURE [dbo].[Category_Delete] @id nvarchar(200) AS BEGIN
UPDATE
  CATEGORY
SET
  IS_DELETED = 1
WHERE
  ID IN (
    select
      *
    from
      dbo.Split(@id, ',')
  ) END