Skip to Content.
Sympa Menu

freetds - RE: [freetds] Another OTL question / problem

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Michael Peppler <mpeppler AT peppler.org>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: RE: [freetds] Another OTL question / problem
  • Date: Thu, 13 May 2004 20:00:59 +0200

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






Archive powered by MHonArc 2.6.24.

Top of Page