How many parameters in a Stored Procedure? 3

[RonRepp]

Hi all:

Is there a way to tell how many parameters are needed to pass into a Stored Procedure?

[code>>Sample]
CREATE PROC RR_Rescodes
(
@StartDate DATETIME,
@EndDate DATETIME
)

AS ...
[/code]

It's obvious that I need 2 here, but what if I couldn't see the SP itself?

Thanks,



Ron Repp

If gray hair is a sign of wisdom, then I'm a genius.

My newest novel: Wooden Warriors

http://www.repproductions.net

 

[ca8msm]

How about

sp_help 'RR_Rescodes'

and look at the parameter list?


-------------------------------------------------------

Mark,
[URL unfurl="true"]http://aspnetlibrary.com[/url]
[URL unfurl="true"]http://mdssolutions.co.uk[/url] - Delivering professional ASP.NET solutions
[URL unfurl="true"]http://weblogs.asp.net/marksmith[/url]

 

[gmmastros]

or....

Select * 
From   Information_Schema.Parameters 
Where  Specific_Name = 'RR_Rescodes'

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[nice95gle]

you could do something like this.

-- For 2000
select Parameter_name from INFORMATION_SCHEMA.PARAMETERS
where Specific_name='RR_Rescodes'
and Parameter_name!=''

--For 2005
select * from sys.parameters
where object_id=object_id('RR_Rescodes')
and name !=''

Well Done is better than well said
- Ben Franklin

 

[RonRepp]

Thanks

Ron Repp

If gray hair is a sign of wisdom, then I'm a genius.

My newest novel: Wooden Warriors

http://www.repproductions.net