SELECT query in a SP in AlwaysOn Availability Group Read Only Routing
Read-only routing is per connection, not per batch or statement. Read-only intent is specified via the application connection string and the connection will be directed to a read-only replica (if possible) when the connection is established.