본문 바로가기

DB/mssql

[mssql] sp명으로 정의 가져오기



SELECT OBJECT_NAME(object_id) AS sp_name, OBJECT_DEFINITION(object_id) AS sp_context FROM sys.procedures WHERE OBJECT_DEFINITION(object_id) like '%{0}%'