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

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Martin (martin_at_hotmail.com)
Date: 06/15/04 

Date: Tue, 15 Jun 2004 18:46:03 +1200

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

  • Re: Get sql server sp Parameters from system tables or sp...
    ... > I have been designing a lot of data-wrappers for my sp's using vb.net and ... > the data access application block. ... > to do this I would like to use a query that given the name of an sp will ...
    (microsoft.public.sqlserver.programming)
  • Generating a one-record ouptut from a query-based data access page
    ... I have a query that will show ... What I want to be able to do is, within the data access page that results ... So if I want more info on "Flying away," clicking ... (create a filter for the target access page, ...
    (microsoft.public.access.gettingstarted)
  • RE: ObjectDatasource - Does it support multiple data tables?
    ... As for the multiple data tables query with objectdatasource, ... we can consider the customization on the data access ... In our custom data access component class, ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Get sql server sp Parameters from system tables or sp...
    ... You can use the INFORMATION_SCHEMA views in SQL Server to get at the ... contains all the parameters for stored procedures. ... > the data access application block. ... > to do this I would like to use a query that given the name of an sp will ...
    (microsoft.public.sqlserver.programming)
  • Re: Data Access Page DataEntry Property = True
    ... that may be the source of your problem; data access pages do ... not allow you as much flexibility in what is an updatable query as do forms. ... >>> getting the following error message when it loads: ... >>> If I change the DataEntry property to false, ...
    (microsoft.public.access.formscoding)