是这样的!比如 declare cursor1 for (select * from test order by test_id desc )如果加上“order by test_id desc ” 就会报错,去掉就好了!请指教!谢谢!
--定义游标是这样的:declare cursor1 cursor for select * from test order by test_id desc
是我将cursor 漏写了!我又查了一下是这个问题 原来我是这么写的declare cursor2 cursor for (select * from test ) 没有错误 后来加上 order by 了 declare cursor2 cursor for (select * from test order by test_id desc ) 就报错了,将括号去掉,就好了!郁闷。再次谢谢zjcxc(邹建) 给分!!!!!!!!!
declare cursor1 for (select * from test order by test_id desc )如果加上“order by test_id desc ” 就会报错,去掉就好了!请指教!谢谢!
原来我是这么写的declare cursor2 cursor for (select * from test ) 没有错误
后来加上 order by 了
declare cursor2 cursor for (select * from test order by test_id desc )
就报错了,将括号去掉,就好了!郁闷。再次谢谢zjcxc(邹建) 给分!!!!!!!!!