Stored Procedure use all command

Question

How to store procedure use all query Please help me.

 

create,alter,drop ,delete,joins,aggregate function in all sp use