USE [AIADatabaseV5] GO /****** Object: StoredProcedure [dbo].[usp_InsertSubscriptionPlan] Script Date: 2/1/2018 12:15:55 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO -- ==================================================== -- Author: Magic Software -- Create date: 10-Jan-2018 -- Description: To insert a subscription plan -- ==================================================== if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[usp_InsertSubscriptionPlan]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[usp_InsertSubscriptionPlan] GO create PROCEDURE [dbo].[usp_InsertSubscriptionPlan] -- Add the parameters for the stored procedure here @Id tinyint, @Title varchar(50), @Price money, @Duration tinyint, @EditionId tinyint, @IsActive bit, @Status bit out AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON; set @Status = 0; BEGIN TRY BEGIN TRANSACTION insert into SubscriptionPlan(Title, Price, Duration, IsActive, EditionId) values(@Title, @Price, @Duration, @IsActive, @EditionId); COMMIT TRANSACTION set @Status = 1; END TRY BEGIN CATCH IF @@TRANCOUNT > 0 ROLLBACK TRANSACTION END CATCH END GO