USE [AIADatabaseV5] GO /****** Object: StoredProcedure [dbo].[usp_DeleteSubscriptionPlan] 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 delete a subscription plan -- ==================================================== if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[usp_DeleteSubscriptionPlan]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[usp_DeleteSubscriptionPlan] GO create PROCEDURE [dbo].[usp_DeleteSubscriptionPlan] -- Add the parameters for the stored procedure here @Id tinyint, @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 delete from SubscriptionPlan where Id = @Id; COMMIT TRANSACTION set @Status = 1; END TRY BEGIN CATCH IF @@TRANCOUNT > 0 ROLLBACK TRANSACTION END CATCH END GO