Locking a data in sql server 2008 or later

I want to lock a table in sql server, but without using 'select' Methode like this: "SELECT * FROM T1 WITH (TABLOCK)" .
There is a very good command in oracle like this:
"LOCK TABLE T1 IN EXCLUSIVE MODE NOWAIT;" .
Please help me: hasanvaez@gmail.com
hasanvaez
Asked Apr 07, 2013

TIP: If it's not your answer to this question, please click "Leave a Comment" button under the question to communicate with the question owner.

Categories