高分求教SQL - MS-SQL Server / 基础类

我现在想得到指定行的下一行，请问怎么得到啊
ID DATE
442 2011-07-08 11:13:49
443 2011-07-09 11:13:49
750
751
780

我现在的目的就是想日期为空的递增实现这种效果,说明下，ID 是不连续的。前面已有日期我是通过游标加进去的，到750就不加了。
ID DATE
442 2011-07-08 11:13:49
443 2011-07-09 11:13:49
750 2011-07-10 11:13:49
751 2011-07-11 11:13:49
780 2011-07-12 11:13:49

---

SQL code:
??
select min(id) from [Table] where date is null

---

SQL code:
??
select min(id) from [Table] where id=443--指定443

---

SQL code:

declare @date datetime

update tb
set @date = dateadd(day,1,[date]),[date] = @date

？？？

---

SQL code:
create table tb(ID int,DATE datetime)
insert into tb values(442 ,'2011-07-08 11:13:49')
insert into tb values(443 ,'2011-07-09 11:13:49')
insert into tb values(750,null)
insert into tb values(751,null)
insert into tb values(780,null)
go

select id , DATE = case when date is not null then date else (sele