usp_GetModestyForThisLicense.sql
1.3 KB
USE [AIADatabaseV5]
GO
/****** Object: StoredProcedure [dbo].[usp_GetModestyForThisLicense] Script Date: 9/12/2018 1:02:41 PM ******/
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
AS
BEGIN
Select IsModesty from LicenseToEdition WHERE LicenseId = @licenseId
end