SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[usp_InsertUpdateLicenseUserGroup]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[usp_InsertUpdateLicenseUserGroup] GO -- ==================================================== -- Author: Magic Software -- Create date: 12-Feb-2018 -- Description: To insert or update a user group of a license -- ==================================================== create PROCEDURE [dbo].[usp_InsertUpdateLicenseUserGroup] -- Add the parameters for the stored procedure here @Id int, @LicenseId int, @Title varchar(100), @CreationDate datetime, @ModifiedDate datetime, @IsActive bit, @Status bit out AS BEGIN SET NOCOUNT ON; set @Status = 0; BEGIN TRY BEGIN TRANSACTION if(@Id = 0) begin insert into UserGroup(LicenseId, Title, CreationDate, ModifiedDate, IsActive) values(@LicenseId, @Title, @CreationDate, @ModifiedDate, @IsActive); end else begin update UserGroup set Title = @Title, CreationDate = @CreationDate, ModifiedDate = @ModifiedDate, @IsActive = @IsActive where Id = @Id; end COMMIT TRANSACTION set @Status = 1; END TRY BEGIN CATCH IF @@TRANCOUNT > 0 ROLLBACK TRANSACTION END CATCH END GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO