How to Select SP by Using SQL Query

Question

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

HappyGeek SSCoach Points: 18729 More actions · Answer 1

If you mean you want the text of the proc then

select ROUTINE_NAME, ROUTINE_DEFINITION from information_schema.routines

where ROUTINE_TYPE = 'PROCEDURE'

or

exec sp_helptext 'MyDb.dbo.myproc'

HTH

...

rabbanishaik.net SSC Journeyman Points: 99 More actions · Answer 2

SSC Journeyman

Points: 99

May 28, 2018 at 5:26 am

Thanks, Team.