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_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
insert into [dbo].[test] values(NEWID(),'第一期','2021-07-12 00:00:00:000','2021-07-14 23:59:59:998')
insert into [dbo].[test] values(NEWID(),'第二期','2021-07-16 00:00:00:000','2021-07-16 23:59:59:998')
insert into [dbo].[test] values(NEWID(),'第三期','2021-07-18 00:00:00:000','2021-07-20 23:59:59:998')
insert into [dbo].[test] values(NEWID(),'第四期','2021-07-22 00:00:00:000','2021-07-23 23:59:59:998')
GO
select * from [dbo].[test]
GO
declare @start datetime,@end datetime
--set @start='2021-07-12 00:00:00:000'
--set @end='2021-07-14 23:59:59:998'
set @start='2021-07-13 00:00:00:000'
set @end='2021-07-15 23:59:59:998'
select * from [dbo].[test] where (StartTime>=@start and StartTime <=@end ) or (EndTime>=@start and EndTime <=@end)