php - SQL Server 2008 R2 - Retrieving procedure input / output parameters -

php - SQL Server 2008 R2 - Retrieving procedure input / output parameters -

i developing application in php connected sql server 2008 r2, requirement getting list of input / output parameters (metadata) procedure(s) , generating run time forms on screen. have around 50 scenarios e.g. order details, pending orders etc.

so instead of developing 50 screens,i have decided generate these forms on run time. googled problem bit , came know feature given in sql server 2012 using sp_describe_first_result_set. reference: link

is there way accomplish in sql server 2008?

the next query returns list of stored procedures , parameters current database:

select pr.object_id [procedure_id] , pr.name [procedure_name] , p.parameter_id , p.name [parameter_name] , p.is_output sys.parameters p bring together sys.procedures pr on p.object_id = pr.object_id order pr.object_id, p.parameter_id

php sql-server sql-server-2008 stored-procedures metadata