if exists(SELECT * FROM dbo.TB AS S1 JOIN TB AS S2 ON S1.ID <> S2.ID AND (S2.endtime > S1.bgnTime AND S2.bgnTime < S1.endtime)) rollback
把他们的起始时间和结束时间的日期between and一下,如果有2条或以上就证明重复了。
引用 7 楼 tanleittl 的回复:SQL code?? 12345 if exists(SELECT * FROM dbo.TB AS S1 JOIN TB AS S2 ON S1.ID <> S2.ID AND (S2.endtime > S1.bgnTime AND S2.bgnTime < S1.endti……
SQL code?? 12345 if exists(SELECT * FROM dbo.TB AS S1 JOIN TB AS S2 ON S1.ID <> S2.ID AND (S2.endtime > S1.bgnTime AND S2.bgnTime < S1.endtime)) rollback
SQL code??12345if exists(SELECT * FROM dbo.TB AS S1 JOIN TB AS S2 ON S1.ID <> S2.ID AND (S2.endtime > S1.bgnTime AND S2.bgnTime < S1.endtime)) rollback
27,579
社区成员
68,558
社区内容
加载中
试试用AI创作助手写篇文章吧