GilaMonster (9/25/2013)

---

enriquezreyjoseph (9/24/2013)

---

But some post say that..Dynamic Sql is a powerful tool...

Indeed, but you don't use a jackhammer to put a nail in the wall. Powerful tool != use all the time

can you give me a strong justification why should i stop using dynamic SQL?? PLEASE 🙁

Harder to write. Much harder to read. Very hard to debug. Vulnerable to SQL injection. Requires elevated permissions. I could go on. When I do code reviews, code that uses dynamic SQL for no good reason goes straight back to the developer to fix.