Is it possible to include lock hints (particularly for SQL Server 2005 where they are called table-level hints) during a fetch just like in the following code (in the context of a transaction):
SELECT ... From [table_name] WITH (UPDLOCK, ROWLOCK) WHERE Id = ...
which is be very handy for a finer control over locking.
