How do you use sp_getProcedureColumns()?

Question

How do you use sp_getProcedureColumns()?

I cannot find any documentation for it.

Thanks,

Howard

Answer 1

I am unsure why that system procedure is not documented. However, I believe it uses the same syntax as sp_GetColumns. For example,

execute procedure sp_getProcedureColumns(null, null, 'myAEP', null );

And based on a comment in another question, you might also be interested in AdsCommand.DeriveParameters. Here is an example:

AdsCommand cmd = conn.CreateCommand();
cmd.CommandText = "SomeProcedure";
cmd.CommandType = CommandType.StoredProcedure;
cmd.DeriveParameters();
foreach ( AdsParameter p in cmd.Parameters )
   Console.WriteLine( "{0}, {1}, {2}", p.ParameterName, p.DbType.ToString(), 
                        p.Direction.ToString() );

Answer 2

Thanks,

This procedure makes the job of parsing out the input and output parameters easier.

Answer 3

Mark,

What are the names of the input parameters?

Thanks,

Howard