dbo.NewUpdateCommand.StoredProcedure.sql 1.45 KB
USE [AIADatabaseV5]
GO
/****** Object:  StoredProcedure [dbo].[NewUpdateCommand]    Script Date: 02/06/2018 10:49:31 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[NewUpdateCommand]
(
	@Title varchar(50),
	@Priority tinyint,
	@IsActive bit,
	@Original_Id tinyint,
	@Original_Title varchar(50),
	@Original_Priority tinyint,
	@Original_IsActive bit,
	@Id tinyint
)
AS
	SET NOCOUNT OFF;
UPDATE [Edition] SET [Title] = @Title, [Priority] = @Priority, [IsActive] = @IsActive WHERE (([Id] = @Original_Id) AND ([Title] = @Original_Title) AND ([Priority] = @Original_Priority) AND ([IsActive] = @Original_IsActive));
	
SELECT Id, Title, Priority, IsActive FROM Edition WHERE (Id = @Id)
GO