这里谁用过SQL SERVER的编程接口函数？如何取得一个存储过程的出口参数值？

2008-04-14 05:50:26 98 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

SQL Server 存储过程示例 --有输入参数的存储过程-- create proc GetComment (@commentid int) as select * from Comment where CommentID=@commentid --有输入与输出参数的存储过程-- create proc GetCommentCount @newsid int, @count int output as select @cou 阅读详情

DB_LIBRAY是SQL SERVER的编程接口函数的一个体系，
问一下，用这些编程接口执行存储过程时，
通过什么API取得该存储过程的出参和返回值？

// 下面是一些相关API，但找不到如何取存储过程的出口参数值和返回值的函数API ！
typedef BYTE * (*p_dbinit)(void);
typedef RETCODE (*p_dbsetlogintime)(INT);
typedef LOGINREC* (*p_dblogin)(void);
typedef DBPROCESS* (*p_dbopen)(LOGINREC *,char *);
typedef void (*p_dbsetlname)(LOGINREC *,char *,int );
typedef RETCODE (*p_dbuse)(DBPROCESS *,char *);
typedef RETCODE (*p_dbcmd)(DBPROCESS *,char *);
typedef RETCODE (*p_dbcmdrow)(DBPROCESS *);
typedef RETCODE (*p_dbsqlexec)(DBPROCESS *);
typedef RETCODE (*p_dbsqlok)(DBPROCESS *);
typedef RETCODE (*p_dbsqlsend)(DBPROCESS *);
typedef void (*p_dbwinexit)(void);
typedef RETCODE (*p_dbresults)(DBPROCESS *);
typedef RETCODE (*p_dbnextrow)(DBPROCESS *);
typedef RETCODE (*p_dbbind)(DBPROCESS *,int,int,DBINT,BYTE *);
typedef RETCODE (*p_dbcancel)(DBPROCESS *);
typedef RETCODE (*p_dbclose)(DBPROCESS *);
typedef void (*p_dbexit)(void);
typedef void (*p_dbclrbuf)(DBPROCESS *,DBINT);
typedef INT (*p_dbcollen)(DBPROCESS *,int);
typedef char * (*p_dbcolname)(DBPROCESS *,int);
typedef INT (*p_dbcoltype)(DBPROCESS *,int);
typedef INT (*p_dbcolntype)(DBPROCESS *,int);
typedef INT (*p_dbcolutype)(DBPROCESS *,int);
typedef DBINT (*p_dbcount)(DBPROCESS *);
typedef char * (*p_dbdata)(DBPROCESS *,int);
typedef DBUBOOL (*p_dbdataready)(DBPROCESS *);
typedef DBINT (*p_dbdatlen)(DBPROCESS *,int);
typedef RETCODE (*p_dbdatecrack) (PDBPROCESS dbproc,LPDBDATEREC dateinfo,LPCDBDATETIME datetime );
typedef DBUBOOL (*p_dbdead)(DBPROCESS *);
typedef DBERRHANDLE_PROC (*p_dberrhandle)(DBERRHANDLE_PROC);
typedef DBMSGHANDLE_PROC (*p_dbmsghandle)(DBMSGHANDLE_PROC);
typedef DBERRHANDLE_PROC (*p_dbprocerrhandle)(HANDLE *,DBERRHANDLE_PROC);
typedef DBMSGHANDLE_PROC (*p_dbprocmsghandle)(HANDLE *,DBMSGHANDLE_PROC);
typedef RETCODE (*p_dbfcmd)(DBPROCESS *,char *,...);
typedef DBINT (*p_dbfirstrow)(DBPROCESS *);
typedef DBINT (*p_dblastrow)(DBPROCESS *);
typedef BOOL (*p_dbiscount)(DBPROCESS *);
typedef INT (*p_dbnumcols)(DBPROCESS *);
typedef INT (*p_dbnumorders)(DBPROCESS *);
typedef INT (*p_dbnumrets)(DBPROCESS *);
typedef INT (*p_dbordercol)(DBPROCESS *,INT);
typedef RETCODE (*p_dbrows)(DBPROCESS *);
typedef STATUS (*p_dbrowtype)(DBPROCESS *);
typedef DBINT (*p_dbretstatus)(DBPROCESS *);
typedef int (*p_dbserverenum)(USHORT,char *,USHORT,unsigned short * );
typedef RETCODE (*p_dbcolinfo)(DBPROCESS *, INT, DBINT, DBINT, DBCOL *);
typedef void (*p_dbfreelogin)(PLOGINREC);
typedef LPVOID (*p_dbgetuserdata)(DBPROCESS *);
typedef void (*p_dbsetuserdata)(DBPROCESS *, LPVOID);
typedef SHORT (*p_dbgetmaxprocs)(void);
typedef void (*p_dbsetmaxprocs)(SHORT);
typedef LPCSTR (*p_dbname)(DBPROCESS *);
typedef LPCSTR (*p_dbchange)(DBPROCESS *);

...全文