freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
- 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
-
Re: [freetds] Another OTL question / problem
, (continued)
-
Re: [freetds] Another OTL question / problem,
Frediano Ziglio, 05/11/2004
-
RE: [freetds] Another OTL question / problem,
Piet De Jong, 05/12/2004
-
RE: [freetds] Another OTL question / problem,
Frediano Ziglio, 05/13/2004
- RE: [freetds] Another OTL question / problem, Piet De Jong, 05/13/2004
- Re: [freetds] Another OTL question / problem, James K. Lowden, 05/13/2004
- Re: [freetds] Another OTL question / problem, Martin Spott, 05/13/2004
-
RE: [freetds] Another OTL question / problem,
Frediano Ziglio, 05/13/2004
-
RE: [freetds] Another OTL question / problem,
Piet De Jong, 05/12/2004
- FW: [freetds] Another OTL question / problem, Piet De Jong, 05/11/2004
- RE: [freetds] Another OTL question / problem, ZIGLIO, Frediano, VF-IT, 05/13/2004
- RE: [freetds] Another OTL question / problem, ZIGLIO, Frediano, VF-IT, 05/13/2004
-
RE: [freetds] Another OTL question / problem,
Lowden, James K, 05/13/2004
- RE: [freetds] Another OTL question / problem, Michael Peppler, 05/13/2004
-
Re: [freetds] Another OTL question / problem,
Frediano Ziglio, 05/11/2004
Archive powered by MHonArc 2.6.24.