dbo.NewInsertCommand.StoredProcedure.sql 994 Bytes

Edit Raw Blame History

USE [AIADatabaseV5]
GO
/****** Object:  StoredProcedure [dbo].[NewInsertCommand]    Script Date: 02/06/2018 10:49:31 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[NewInsertCommand]
(
	@Title varchar(50),
	@Priority tinyint,
	@IsActive bit
)
AS
	SET NOCOUNT OFF;
INSERT INTO [Edition] ([Title], [Priority], [IsActive]) VALUES (@Title, @Priority, @IsActive);

SELECT Id, Title, Priority, IsActive FROM Edition WHERE (Id = SCOPE_IDENTITY())
GO