insert update select storprocedure

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE PROCEDURE [dbo].[AddUpdateCustomer]

      @CustomerID NCHAR(5),

      @ContactName NVARCHAR(30),

      @CompanyName NVARCHAR(40)

AS

BEGIN

      SET NOCOUNT ON;

    IF EXISTS(SELECT * FROM Customers WHERE CustomerID = @CustomerID)

    BEGIN

            UPDATE [Customers]

            SET [CompanyName] = @CompanyName

               ,[ContactName] = @ContactName

            WHERE CustomerID = @CustomerID

    END

    ELSE

    BEGIN

            INSERT INTO [Customers]

           ([CustomerID]

           ,[CompanyName]

           ,[ContactName])

        VALUES

           (@CustomerID

           ,@CompanyName

           ,@ContactName)

    END

   

    SELECT [CustomerID]

          ,[CompanyName]

          ,[ContactName]

      FROM Customers         

END