[freetds] Another OTL question / problem
mpeppler at peppler.org
Thu May 13 14:00:59 EDT 2004
On Thu, 2004-05-13 at 15:51, Lowden, James K wrote:
> > From: freetds-bounces at lists.ibiblio.org
> > [mailto:freetds-bounces at lists.ibiblio.org]On Behalf Of
> > > On Thu, 13 May 2004, Frediano Ziglio <freddyz77 at tin.it> wrote:
> > > > - getting store procedure informations (I don't know how)
> > >
> > > What information, exactly?
> > The first recordset types returned (and possibly store procedure
> > parameters list)
> Then comes this glorious Alice-in-Wonderland observation:
> "In SQL Server, only the column information about input and output
> parameters for the stored procedure are [sic] returned."
> One wonders what besides SQL Server runs sp_sproc_columns?
In any case it is impossible to know what result sets and columns a proc
might return without running it, as it may very well return completely
different result sets when passed different parameters. Consider:
create proc my_proc @flag int
if @flag = 1
select * from sysusers
select * from sysobjects
Michael Peppler Data Migrations, Inc.
mpeppler at peppler.org http://www.peppler.org/
Sybase T-SQL/OpenClient/OpenServer/C/Perl developer available for short
or long term contract positions - http://www.peppler.org/resume.html
More information about the FreeTDS