difference b/w sp and dynamic sp?
simple example in dynamic stored procedure?
when we will use dynamic sp?
advantages of dynamic sp?
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Jan MontanoPosted Jun 1, 2007, 1:23 AM
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