SQL: Drop all stored procedures in database

Here is a useful SQL script to drop all stored procedures in the selected database. The code is valid for MS SQL.

DECLARE @ProcName varchar(500)

DECLARE cur CURSOR
FOR SELECT Name FROM sys.procedures
OPEN cur
     FETCH NEXT FROM cur INTO @ProcName
     WHILE @@fetch_status = 0
     BEGIN
          EXEC ('DROP PROC ' + @ProcName)   
          FETCH NEXT FROM cur INTO @ProcName
     END
CLOSE cur
DEALLOCATE cur