OPEN"处有错误?

[it_sql]

DECLARE @a datetime,@b varchar(50),@c float
DECLARE @a1 datetime,@b1 varchar(50),@c1 float

DECLARE c1 CURSOR FOR
SELECT a,b,c from table

DECLARE c2 CURSOR FOR
SELECT a,b,c from table1

OPEN c1
FETCH NEXT FROM c1 INTO @a,@b,@c

OPEN c2
FETCH NEXT FROM c2 INTO @a1,@b1,@c1
为什么会提示在关键字"OPEN"处有错误?各位老大帮忙看看,是SQL2000的

[中国风]

--表名为table时加上[],语法没问题
SELECT a,b,c from [table]

[it_sql]

我知道啊 ,呵呵，但是还是提示OPEN关键字有错啊,郁闷啊..

[kuangdp]

贴出整个游标使用过程看看