现在要把oracle下的package&packagebody 改写到sqlserver下的procedure或者function下,在package里有如下定义
type rec_column_type is record
(c_id sys_column_info.column_id%type,
cname_eng sys_column_info.column_name_eng%type,
cname_chn sys_column_info.column_name_chn%type);
--定义:域信息返回游标(ref cursor)
type c_column_type is ref cursor return rec_column_type;
上面的记录和游标在sqlserver 中如何实现?多谢了