SELECT column
FROM table WITH (ROWLOCK).
-----Original Message-----
From: Paul Hastings [mailto:[EMAIL PROTECTED]
Sent: December 24, 2003 10:23 AM
To: CF-Talk
Subject: Re: CFTRANSACTION & CFLOCK
> > Actually, you can only suggest isolation levels to DB, the DB
> > is the one that sets isolation levels and does what it think
> > is the best thing.
>
> While I imagine this could be true for some database, it certainly isn't
> true for either SQL Server or Oracle. I don't even think it's true for
> locking hints in SQL Server, although I use them infrequently enough that
I
> could be wrong about that.
for sql server no explicit locking hint or transaction isolation level hands
this decision off to the optimizer which determines the (usually) best type
of locking to apply. as far as i know & from what i can find in BoL, locking
hints are 100% enforced except for transactions that muck with the "schema
stability" (can't have you ripping a table's innards apart while joe blow is
updating it). ditto for isolation levels. btw locking hints are table
level.
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
