SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: <Author,,Name>
-- Create date: <Create Date,,>
-- Description: 验证分类的开始值或结束值是否存在于列表中
-- =============================================
ALTER PROCEDURE gen_LoadSharing_Exists_Value
-- Add the parameters for the stored procedure here
@id int,@SectionStart int,@SectionEnd int,@ProductionTypeID int
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
-- Insert statements for procedure here
IF EXISTS( select ID from LoadSharing
where ((SectionStart between @SectionStart and @SectionEnd)
or(SectionEnd between @SectionStart and @SectionEnd)
or(@SectionEnd between SectionStart and SectionEnd)
or(@SectionStart between SectionStart and SectionEnd)) and ProductionTypeID=@ProductionTypeID and (ID!=@id OR @id=-1) )
SELECT 1
ELSE
SELECT 0
END
GO
区间段是否存在重叠值
最新推荐文章于 2023-02-13 15:51:25 发布