updating a variable in stored procedure using query

Question

Hi There,

     I have a requirement where i have to update all stored procedures in my server which has a constant variable i have to updated all my stored procedures
based on that constant variable using a single query/stored procedure.

     can any one please anyone help me with this requirement.