Retrieving by program the parameter list of a stored procedure ?

"Philippe
Date: 01/16/04 

Date: 16 Jan 2004 02:15:01 -0700

Hi all,

I know how to retrieve programmatically the list of all stored procedures in an ADO database (ADOConnection.GetProcedureNames), but is it possible to know the list of parameters of a given store procedure by program?

Thanks in advance,

Philippe

Relevant Pages

  • Re: Amazming....but curious...
    ... If you are using stored procedures for all of your work, it should not matter, as you are explicitly choosing the columns. ... procedure for Fill Query in table adapter.... ... is this insertion done by store procedure or just SQL text?...I guess SQL ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: How does OWSSVR.dll call proc_FetchDocForHttpGet stored procedure?
    ... as the stored procedures could be called from other ... In any case, I appreciate your advice! ... So if you want to research the dll internal on how to reach the store procedure, I'd suggest you can use SQL profiler to monitor the SQL ...
    (microsoft.public.sharepoint.portalserver.development)
  • Re: Help on SQLAdapter Command ???
    ... one used for the store procedure to create the Insert, Delete command. ... Are you sure that you use stored procedures? ... As soon as I do the same thing for the DeleteCommand, ...
    (microsoft.public.dotnet.framework.adonet)
  • possible to group stored procedures?
    ... you can group them into one store procedure using ... design. ... I have several stored procedures for a particular ... >or something like folders to group the sp's? ...
    (microsoft.public.sqlserver.programming)