procedure details - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

procedure details

Author

Topic

xpandre
Posting Yak Master

212 Posts

Posted - 2002-05-03 : 10:38:17

hi,
Is there any way of getting list of all the input parameters for a stored proc?(as we get in the object browser in query analyzer)
tahnx
sam

YellowBug
Aged Yak Warrior

616 Posts

Posted - 2002-05-03 : 10:54:49

sp_help 'up_myproc'

OR

select * from INFORMATION_SCHEMA.PARAMETERS

OR

select O.name, C.*
from sysobjects O INNER JOIN syscolumns C ON O.id = C.id
where O.type = 'P'

xpandre
Posting Yak Master

212 Posts

Posted - 2002-05-03 : 11:16:53

thanx a lot!!:D

MichaelP
Jedi Yak

2489 Posts

Posted - 2002-05-03 : 13:45:45

Like I posted on your other post
sp_helptext ProcName
might help you as well.

Michael

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources