Re: Get sql server sp Parameters from system tables or sp...

From: SriSamp (ssampath_at_sct.co.in)
Date: 06/15/04 

Date: Tue, 15 Jun 2004 12:41:01 +0530

You can use the INFORMATION_SCHEMA views in SQL Server to get at the
information that you want. For example: INFORMATION_SCHEMA.PARAMETERS
contains all the parameters for stored procedures. 

-- 
HTH,
SriSamp
Please reply to the whole group only!
http://www32.brinkster.com/srisamp
"Martin" <martin@hotmail.com> wrote in message
news:%23z47vPqUEHA.3332@tk2msftngp13.phx.gbl...
> Hi,
>
> I have been designing a lot of data-wrappers for my sp's using vb.net and
> the data access application block.
> seeing as all of these follow a similar pattern I though I might automate
> the process by writeing some code that will "generate code" for the data
> access wrapper.
>
> to do this I would like to use a query that given the name of an sp will
> return the name of all parameters, the type, size (will be needed if it is
a
> varchar) and the parameters order, as well as if they are input or output
> parameters, not sure if you can detect a return value parameters???
>
> could anybody please point out the best way for me to do this please, I am
> guessing that I will have to query the system tables somehow or use a
system
> sp.
>
>
> any help is graetly appreciated.
>
> cheers
>
> martim.
>
>

Relevant Pages

  • Extreme performance issues (SQL Server 2000/ADO.NET/C#)
    ... This process runs very quickly if run through Query ... same exact stored procedures and views, run in the same exact order, through ... system that runs SQL Server (a 4-cpu Xeons system with 2gigs of physical ... When I execute these steps manually through query analyser,, ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: SQL Server
    ... Where is the processing done in a pass through query? ... One of the SQL Server programmers is pushing stored procedures, ... pass-through queries. ...
    (microsoft.public.access.queries)
  • Re: ORDER BY in VIEW not working
    ... a query to get an ordered data set, it's not okay to store that query as ... There are stored procedures, and thus there is a solution. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (comp.databases.ms-sqlserver)
  • Re: Access migration to SQL Server
    ... about having to convert all your queries to views and stored procedures. ... so SQL Server won't have to keep recompiling each query ...
    (microsoft.public.access.conversion)
  • Re: Access migration to SQL Server
    ... about having to convert all your queries to views and stored procedures. ... so SQL Server won't have to keep recompiling each query ...
    (microsoft.public.sqlserver.server)