This figure shows the decision logic that will help you choose the right method for using dynamic SQL.