By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
/*Comment header*/
CREATE OR ALTER PROCEDURE example_procedure
AS
SELECT 1 AS Id
SELECT [definition]
FROM sys.sql_modules
WHERE [object_id] = OBJECT_ID('example_procedure')
| definition |
|---|
| /*Comment header*/ CREATE PROCEDURE example_procedure AS SELECT 1 AS Id |