We all know that dynamic SQL runs in its own scope (see here for details), and that if used improperly it can have serious security implications. But it's also important to realize that dynamic SQL evaluates your SQL statements more like a stored procedure
Read More...