dbo.NewDeleteCommand.StoredProcedure.sql
1.03 KB
USE [AIADatabaseV5]
GO
/****** Object: StoredProcedure [dbo].[NewDeleteCommand] Script Date: 02/06/2018 10:49:31 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
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