Re: how to get names and types of parameters of stored procedure

From: AnthonyThomas (Anthony.Thomas_at_CommerceBank.com)
Date: 12/22/04 

Date: Wed, 22 Dec 2004 05:44:41 -0600

There is also a stored procedure, sp_proc_columns, I believe, that will
parse out that information for you.

Sincerely,

Anthony Thomas 

-- 
"Jacco Schalkwijk" <jacco.please.reply@to.newsgroups.mvps.org.invalid> wrote
in message news:%23dhtDeB6EHA.1564@TK2MSFTNGP09.phx.gbl...
You can find this information in the information_schema.parameters view.
-- 
Jacco Schalkwijk
SQL Server MVP
"Leo" <Leo@discussions.microsoft.com> wrote in message
news:D7FE4664-3595-4EC7-8EE3-C453B4823E74@microsoft.com...
> Hi everybody!
>
> I need to get names and types of parameters of stored procedures  from
> some
> system tables.
> ( not from SQLDMO object ) . Does somebody know in what system table(s)
> these data stored?
>
> Thanks
>
>

Relevant Pages

  • Re: Problems using a Table Variable
    ... Persson" wrote in message ... >>>>UPDATE @TaskOrg t>>..... ... >>>>should work>>>>-->>Jacco Schalkwijk>>SQL Server MVP>> ... >>> In our system I have discovered that a stored procedure,>>> changed by some of my ...
    (microsoft.public.sqlserver.programming)
  • Re: I have a problem with an article I want to be published under two categories.
    ... You can just call the stored procedure twice, once for each category if you ... > "Jacco Schalkwijk" wrote in message ... The Primary key on this table is a composite ... >> SQL Server MVP ...
    (microsoft.public.sqlserver.programming)
  • Re: Query about the LIKE statement
    ... Step2: ... In my stored procedure, ... select (blah blah many cases and all that for cross tab reports) ... >> Jacco Schalkwijk ...
    (microsoft.public.sqlserver.programming)
  • Re: Performance using coalesce()
    ... Jacco Schalkwijk wrote: ... > Note that I use a (stored procedure) parameter, ... > variables ususally prevents the query optimizer from generating the optimal ... Zach ...
    (microsoft.public.sqlserver.programming)
  • Re: Help In Stored Procedure
    ... Jacco Schalkwijk ... SQL Server MVP ... this in stored procedure or through query also. ... > If anybody know any other method or a better procedure plz help ...
    (microsoft.public.sqlserver.server)