USE [AIADatabaseV5] GO /****** Object: StoredProcedure [dbo].[NewDeleteCommand] Script Date: 2/1/2018 12:15:55 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[NewDeleteCommand]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[NewDeleteCommand] GO CREATE PROCEDURE [dbo].[NewDeleteCommand] ( @Original_Id tinyint, @Original_Title varchar(50), @Original_Priority tinyint, @Original_IsActive bit ) AS SET NOCOUNT OFF; DELETE FROM [Edition] WHERE (([Id] = @Original_Id) AND ([Title] = @Original_Title) AND ([Priority] = @Original_Priority) AND ([IsActive] = @Original_IsActive)) GO