Re: get stored procedure structure

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Patrice (nobody_at_nowhere.com)
Date: 03/01/05


Date: Tue, 1 Mar 2005 17:37:21 +0100

AFAIK no "built-in ADO.NET support" but you can always select directly from
the Information_Schema.Routines view or call any sp you need (such as
sp_helptext to get the text of a SP).

Patrice

-- 
"St" <st@nospam.please> a écrit dans le message de
news:%23iF9psnHFHA.1604@TK2MSFTNGP10.phx.gbl...
> Hello,
>
> is it possible to get stored procedure from sql server ? For exemple, I am
> using
> GetSchemaTable to get schema from a table, but is it possible with a
stored
> procedure ?
>
> Thanks
>
> St
>
>


Relevant Pages

  • RE: VS2008 & SQL Server Debugging
    ... The bug happens when the parameter of the stored procedure is user defined ... defined type parameter ... Check the output window from Debug output after it fails to step into ... Microsoft Online Community Support ...
    (microsoft.public.vsnet.debugging)
  • RE: Linq to SQL Decimal output Parameters
    ... Initially when I encountered this problem I was mapping a stored procedure ... Regarding on this LINQ sp issue, I've performed some test according to the ... System.NullableparamValue) ... Microsoft MSDN Online Support Lead ...
    (microsoft.public.dotnet.framework.adonet)
  • RE: Non initialized Cmd Parameter Collection via ASP vs SQL Server
    ... component to access database and execute some stored procedure. ... error when change the database from SQL server 2000 to SQL Server 2005, ... Microsoft MSDN Online Support Lead ... Delighting our customers is our #1 priority. ...
    (microsoft.public.data.ado)
  • RE: Compatibility (2002->2003)
    ... The combo box's rowsource is set to the name of the stored procedure, ... The following sub is called to requery the combo box when required. ... Microsoft Online Community Support ... or a Microsoft Support Engineer within 1 business day is acceptable. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Datagrid example
    ... Microsoft MSDN Online Support Lead ... You can send feedback directly to my manager at: ... Creates a gridview control with the results of a SQL stored procedure ...
    (microsoft.public.dotnet.framework.aspnet)