记录一个小问题：游标中声明排序的写法问题
开始写
declare mycursor cursor for( select * from tableName)deallocate mycursor
declare mycursor cursor for( select * from tableName order by field1 ) deallocate mycursor
提示order 附近有语法错误
最后发现正确写法
declare mycursor cursor forselect * from tableName order by field1deallocate mycursor
或者
declare mycursor cursor for( select * from tableName ) order by field1 deallocate mycursor
posted @ 2007-06-15 10:33 雨人(ralpher) 阅读(234) 评论(0) 收藏 举报
