what is dynamic stored procedure ? what is their relation with dynamic functions and dynamic queries?

how do we implement dynamic stored procedure and do they relate to dynami开发者_StackOverflowc functions and dynamic queries in sql server ?

Kindly enlighten...

There is only dynamic SQL which refers to the practice of creating a T-SQL text and executing it using the sp_executesql (or simply exec): The Curse and Blessings of Dynamic SQL.

Stored procedures can execute dynamic SQL, functions cannot.