usp_GetModestyForThisLicense
693 Bytes
USE [AIADatabaseV5]
GO
/****** Object: StoredProcedure [dbo].[usp_GetModestyForThisLicense] Script Date: 09/26/2018 08:02:49 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- ====================================================
-- Author: Magic Software
-- Create date: 29-Jan-2018
-- Description: To get a license information on the basis of LicenseId
-- ====================================================
ALTER PROCEDURE [dbo].[usp_GetModestyForThisLicense]
-- Add the parameters for the stored procedure here
@licenseId int,
@editionId tinyint
AS
BEGIN
Select IsModesty from LicenseToEdition WHERE LicenseId = @licenseId and EditionId = @editionId
end