Re: Get sql server sp Parameters from system tables or sp...
From: Martin (martin_at_hotmail.com)
Date: 06/15/04
- Next message: Uri Dimant: "Re: Get sql server sp Parameters from system tables or sp..."
- Previous message: Uri Dimant: "Re: Help creating a job to monitor transaction in a table"
- In reply to: SriSamp: "Re: Get sql server sp Parameters from system tables or sp..."
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 15 Jun 2004 19:57:33 +1200
Many thanks
cheers
martin
"SriSamp" <ssampath@sct.co.in> wrote in message
news:%23fA3OeqUEHA.2672@TK2MSFTNGP10.phx.gbl...
> 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.
> >
> >
>
>
- Next message: Uri Dimant: "Re: Get sql server sp Parameters from system tables or sp..."
- Previous message: Uri Dimant: "Re: Help creating a job to monitor transaction in a table"
- In reply to: SriSamp: "Re: Get sql server sp Parameters from system tables or sp..."
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
