How to delete a specific entry or group in one request?

Question

SQL Server

Table of options for naming various objects.

CREATE TABLE [dbo].[Variation](
  [ID] [int] IDENTITY(1,1) NOT NULL,
  [Kind] [char](1) NOT NULL,
  [Object] [int] NOT NULL,
  [Value] [varchar](500) NOT NULL,
  [Key]  AS ([Kind]+CONVERT([varchar],[object]))
)

How to delete a single entry or all entries for a specific object?

Answer 1

CREATE PROCEDURE VariationDelete @KEY VARCHAR(10), @ID INT = -1
AS
  DELETE FROM [Variation]
    WHERE ([Key] = @KEY) AND ((@ID = -1 ) OR (ID = @ID ))
--
GO

When not specified @ID, all entries are deleted by @KEY, when specified, only one entry.