creating stored way fly. risks/problems?

i am pondering formulating stored procedures fly.

ie controlling emanate procedure... (web) concentration running.

what risks problems cause?

• i know database comment needs have additional privileges.


• it does occur everyday. wholly time.


• i am controlling sql server prying mysql postgres well.

update1:

thanks comments, i am deliberation formulating new chronicle stored way switching over instead altering sp. example: sp1 -> sp2 -> sp3

update2:

the reason:

my schema changes since tradition fields (unknown array form columns)
i attempted enterprising sql sp_executesql first. impetus works. enterprising sql works greate 1,2,3 rudimentary update,inserts.

but got too dizzy lot work does brew good stored procedure, problems sql parameterization since used inside stored way array form params famous during accumulate (long story).

at slightest simple unfolding fortitude complicated.
the explanation sp does change. any tradition domain i have supplement new parameter sp supplement buttress update, insert, etc.

i also deliberate origination stored way parameters enterprising sp_executesql accepts any array form params nonetheless way.