Skip to content

Instantly share code, notes, and snippets.

@hancheester

hancheester/view-content-of-a-sp.sql

Last active November 7, 2019 20:29
Show Gist options
  • Save hancheester/ed652414f13075aa16b1c713a0526deb to your computer and use it in GitHub Desktop.
Save hancheester/ed652414f13075aa16b1c713a0526deb to your computer and use it in GitHub Desktop.
Download ZIP
To view content of a stored proc
Raw
view-content-of-a-sp.sql
-- To view content of a stored proc
-- Option 1
exec sp_helptext 'dbo.NameOfTheSp'
-- Option 2
select OBJECT_DEFINITION(OBJECT_ID('NameOfTheSp'))
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment