dee-u PM'd me last night and asked about locking in MS SQL Server when doing an action query like - UPDATE ... WHERE...

I'm looking for opinions and techniques.

How do you all LOCK rows or recordsets? Both INLINE SQL and STORED PROCEDURES.

Thanks in advance.