sql语句判断两个时间段是否有交集
SQL脚本CREATE TABLE [dbo].[test]( [Id] [uniqueidentifier] NOT NULL, [name] [nvarchar](50) NULL, [StartTime] [datetime] NULL, [EndTime] [datetime] NULL, CONSTRAINT [PK_test] PRIMARY KEY CLUSTERED ( [Id] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPU
原创
2021-10-23 16:31:32 ·
335 阅读 ·
0 评论