How do I lock 1 row in a table from an ODBC Connection.
eg. On Oracle I issue:
select * from T where (primary_key) = (some_value) FOR UPDATE;


COnversly how do I test if this 1 row is locked?
eg.On Oracle I:
select * from T where (primary_key) = (some_value) FOR UPDATE NOWAIT;

Is there a similar mechanism on sql server???