Re: MS SQL Server 2000 feature or bug?

Hi Brian,

According to SQL Server Help file: "The INFORMATION_SCHEMA.PARAMETERS view
is based on the sysobjects and syscolumns system tables". Then, later in
the table of columns returned that explains each field, it mentions for
PARAMETER_MODE, type nvarchar(10), "Returns IN if an input parameter, OUT if
an output parameter and INOUT if an input/output parameter." Oh, really???
;)

syscolumns doesn't contain a column to store whether a parameter is an INPUT
parameter. There is only a column to store if it has OUTPUT capabilities.
I have not found a single case in my entire database of well more than 100
stored procedures (most have INPUT and OUTPUT parameters) of any
differential between OUTPUT and INPUT OUTPUT.

Hmmmm... seems to me this is a feature, not a bug! (Its an extra feature
listed in the help file not implemented by the product!) Who knows.. maybe
in a decade or two they might figure this one out! ;) IMHO, SQL Server is
still way more mature than some other products which lack these sort of
"features", but this is rather frustrating to say the least. Why do we
spend the time figuring out if we should declare INPUT OUTPUT versus OUTPUT?
hmmm....

PW

p.s. does anyone reading this thread know of a product that Delphi reads
this value from correctly? Just curious. Back when I was doing a lot of
Interbase development I never had the need.. and thus don't recall if
Interbase had its act together or not. What about Oracle? mySQL?
Informix? Sybase?



"Brian Hollister" <bhollisterATfuturaintlDOTcom> wrote in message
news:43be8f5d$1@xxxxxxxxxxxxxxxxxxxxxxxxx
> Hi,
>
> I would not be so quick to point the finger, but anyway...
>
> Maybe you can put the INFORMATION_SCHEMA.PARAMETERS view to your use
> somehow???
>
> Hth,
>
> brian


.

Relevant Pages

  • Re: Function vs. Sub
    ... "Look it up in the help file" ... It's more in the SQL Server ... The bottom two give you different formats. ... You should look up Sub and Function in Access HELP system. ...
    (microsoft.public.access.formscoding)
  • Re: DTS/SQL 2000 Error on Import: External table is not in the expected format
    ... I just want to pursue the permissions thing further as the error ... The SQL Server Agent Service? ... The package works fine if executed manually. ...
    (microsoft.public.sqlserver.dts)
  • DTS Database copy fails
    ... I am using DTS copy sql server object task to copy data and objects from ... The job has been failing with the following error. ... constraint was there and applied on to destination. ... Help file: SQLDMO80.hlp ...
    (microsoft.public.sqlserver.dts)
  • error in DTSStep_DTSExecutePackageTask.
    ... i'm analyzing the data traslations from oracle tables to SQL server, ... General conversion failure on column pair 1 (source column 'HORAS' ... Help file: sqldts80.hlp ... in SQL server table the column 'HORAS' is NUMERIC. ...
    (microsoft.public.sqlserver.dts)
  • Re: Job fails, but cant find whats wrong
    ... Error source: DTS Data Pump ... Help file: ... Microsoft Data Transformation Services Data Pump ... >> security do I need to set up to make sure the SQL Server ...
    (microsoft.public.sqlserver.dts)