Re: get stored procedure structure
From: Patrice (nobody_at_nowhere.com)
Date: 03/01/05
- Next message: Beve Lyni: "Does ADO.net have equivalent to ADODB.Recordset.GetString() in VB6"
- Previous message: Cor Ligthert: "Re: Dataset performance"
- In reply to: St: "get stored procedure structure"
- Next in thread: Tapio Kulmala: "Re: get stored procedure structure"
- Messages sorted by: [ date ] [ thread ]
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 > >
- Next message: Beve Lyni: "Does ADO.net have equivalent to ADODB.Recordset.GetString() in VB6"
- Previous message: Cor Ligthert: "Re: Dataset performance"
- In reply to: St: "get stored procedure structure"
- Next in thread: Tapio Kulmala: "Re: get stored procedure structure"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|