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: Wanted: Discussion on MSSQL Internals Interview Qustions
    ... Developer for Microsoft's SQL Server team? ... Other inputs the query optimizer uses are the schema ... The C# dataset caching can only cache results from a single query. ... I don't consider these alternatives to stored procedures, ...
    (microsoft.public.sqlserver.programming)
  • 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: Connection from two servers
    ... Try executing the following in Query Analyzer: ... >I have an sql server program which have 2 sql servers servers are registered ... >Server 'ODED' is not configured for DATA ACCESS. ...
    (microsoft.public.sqlserver.security)