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.
精彩评论