摘要:
sampledeclare @a table(Account int) insert into @a values(1 ) insert into @a values(2 ) insert into @a values(3 ) insert into @a values(4 ) insert into @a values(9 ) insert into @a values(10 ) insert into @a values(11 ) insert into @a values(20 ) --缺失的最小ID号 SELECT CASE WHEN NOT EXISTS(SELECT ... 阅读全文