[thelist] capturing returned value from MS-SQL stored procedure

Scott Dexter sgd at ti3.com
Thu Jan 10 18:08:46 CST 2002


instead of an output parameter, do something like

Select @RetVal as PonID
return

as you exit the stored proc. That will return a recordset back to the
caller...

sgd
--
work: http://ti3.com/
non: http://thinksafely.org/ 

> -----Original Message-----
> From: spinhead [mailto:evolt at spinhead.com] 
> 
> Gladly. Any suggestions? I'm not fussy about method, just 
> results. What I'm
> trying to do is avoid making two sequential calls to the db, 
> one to insert,
> then going back to read the max value.




More information about the thelist mailing list