Dynamic SQL is a necessary, lazy throwback. And if Microsoft had any self respect they would kill it unceremoniously this instant in favor of ANYTHING resembling useful.
I would like to point out that there really is no such thing as a "single quote" in the English language. It's actually always an apostrophe. But convention has allowed...