Wednesday, March 21, 2012

Retrieving Parameter List for a Stored Procedure

Is there a way to retrieve the parameter list for a given stored procedure?

I am trying to create a program that will autogenerate a list of stored procedures and their parameters so that changes to the database can be accurately reflected in code.

Thanks,
Allen K.sp_sproc_columns @.Procedure_Name='procedurename'

Column_Name : Type_Name : Precision : Length : Scale : Is_Nullable

No comments:

Post a Comment