>So what are the benefits of SPROCS versus passing commands?
Security, Security, Security!
My web apps have no direct table access rights through the webuser. They have execute rights for SPs and the SPs do all the heavy lifting for CRUD work.
Dynamic SQL is overrated and you need it only once in a while, or at my new contract all the time. ;->