title: Can SQL Transaction lock rows only from specified view
body: <p>In a multi-tenant application I have a table with TenantId column. This table is only accessed using a view which selects rows belonging to a single tenant using TenantId stored in <code>CONTEXT_INFO</code>. Is there a way to have transactions only locking data that this view returns for particular Tenant (ie. lock only rows with the same TenantId)?</p>
  
  <p>It will be a performance loss if I lock the entire table when I'm sure the data being inserted/updated/deleted is never going to collide with those that have a different value in the TenantId column.</p>
  
  <p>That same pattern would apply for any other View which limits some table rows using <code>WHERE</code> clause.</p>