return list of output SPs - 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

Transact-SQL (2000)

return list of output SPs

Author

Topic

rajani
Constraint Violating Yak Guru

367 Posts

Posted - 2005-11-13 : 22:39:51

Hi friends
i want to get list of stored procedures having a "output" parameter.
any idea how can i do that please.
Thanks for your help

shallu1_gupta
Constraint Violating Yak Guru

394 Posts

Posted - 2005-11-14 : 00:13:54

Hi,
U can get it from
SELECT *
FROM [INFORMATION_SCHEMA].[PARAMETERS]
where parameter_mode ='Out' or parameter_mode = 'inOut'--for a parameter behaving as Imput and OUTPUT both.

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2005-11-14 : 00:29:17

Select routine_definition from information_schema.routines where routine_definition like '%output%'

Madhivanan

Failing to plan is Planning to fail

rajani
Constraint Violating Yak Guru

367 Posts

Posted - 2005-11-14 : 14:58:44

quote:
Originally posted by shallu1_gupta

Hi,
U can get it from
SELECT *
FROM [INFORMATION_SCHEMA].[PARAMETERS]
where parameter_mode ='Out' or parameter_mode = 'inOut'--for a

Hi Gupta
That worked beautifully mate.Thank you very much

Cheers

rajani
Constraint Violating Yak Guru

367 Posts

Posted - 2005-11-14 : 15:02:54

quote:
Originally posted by madhivanan
Select routine_definition from information_schema.routines where routine_definition like '%output%'

Hi Madhivanan
your suggestion worked too but i'll use gupta's suggestion as it looks at parameters only.
Thanks.

Cheers

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources