声明存储过程
CREATEPROCEDUREsp_results_demo@InParmIntInt,@OutParmIntOUTPUT
AS
BEGIN
SELECT1,2,3,4
SELECTuid,id
FROMsysobjects
WHEREtype='U'
SELECT@OutParmInt=69
Return16
END
用于返回每个返回值时用PowerScrip如下:
LonglReturn,lPram1,lPram2,lResult1,lResult2,lResult3,lResult4,lResult5,lResult6
DECLAREresults_demoPROCEDUREFOR
@returnValue=sp_results_demo
@InParmInt=:lPram1,
@OutParmInt=:lPram2OUTPUTusingsqlca;
executeresults_demo;
DoWhileSQLCA.SQLCode=0
Fetchresults_demoINTO:lResult1,:lResult2,:lResult3,:lResult4;
Loop
Fetchresults_demoINTO:lResult5,:lResult6;
DoWhilesqlca.sqlcode=0
Fetchresults_demoInto:lResult5,:lResult6;
Loop
Fetchresults_demoInto:lReturn,:lPram2;
Closeresults_demo;
爱好者wdw@gst.com.cn
mailto:imdt@263.net
<script type="text/javascript"> </script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>