Dynamic Stored procedure

Question

difference b/w sp and dynamic sp? simple example in dynamic stored procedure? when we will use dynamic sp? advantages of dynamic sp?

Jan Montano · Answer

You can find here a sample of a dynamic sp http://www.4guysfromrolla.com/webtech/020600-1.shtml Dynamic sps/sql/queries are in some way constructed/modified before calling.I once used dynamic sp when I need to pass an array of strings. advantages & disadvantages below... http://weblogs.asp.net/fbouma/archive/2003/05/14/7008.aspx http://www.sommarskog.se/dynamic_sql.html MUST READ article