USE [AIADatabaseV5] GO /****** Object: StoredProcedure [dbo].[NewInsertCommand] 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].[NewInsertCommand]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[NewInsertCommand] 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