dbo.NewDeleteCommand.StoredProcedure.sql 1.39 KB
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