sqlserver--Transaction One programming advanced (SQL Server Technology Insider T-SQL Programming Chapter Nineth

Generally do not modify the default level of SQL Server transactions. Forced lock is not recommended

1 Execute EXEC sp_lock report information about the lock

1 How to lock a row in a table

SET TRANSACTION Isolation Level READ UNCOMMITTED

SELECT * FROM table rowlock WHERE id = 1

2 locking a table for a database

SELECT * from table with (HOLDLOCK)

Add lock Statement:

Sybase:

Update table set col1=col1 where 1=0;

MSSQL:

Select col1 from table (Tablockx) where 1=0;

Oracle

LOCK table table in EXCLUSIVE MODE;

Locking after the other person is not operational until the lock user unlocked, with a commit or rollback unlock

sqlserver--Transaction One programming advanced (SQL Server Technology Insider T-SQL Programming Chapter Nineth