Store Procedure parameter

[faizurrahman]

I want to write a store procedure which accept anothor store procedure as parameter and then retrun the datatypes of input variables of given store procedure. Plz help if any one knows n how to do it.

[Ashfield]

You can pick up the definition of the stored proc from syscomments -

select text from syscomments where id = object_id('procname')

and concat all the comments together, then parse for the parameters.

Bob Ashfield Consultants Ltd

[faizurrahman]

Thank you I have got solution by a simple query: select * from information_schema.Parameters where specific_Name = 'ProceName'

[Ashfield]

You learn something every day. I'll keep that view in mind. :)

Bob Ashfield Consultants Ltd