[freetds] Another OTL question / problem

Michael Peppler 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
as
if @flag = 1
   select * from sysusers
else
   select * from sysobjects
go

Michael
-- 
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 mailing list