BEGIN DISTRIBUTED TRANSACTION TABLOCKX
SELECT * FROM openrowset('sqloledb','REMOTE_SERVER_NAME';'SA';'',DB_NAME.dbo.TABLE_NAME)
commit transaction没锁住远程照样能插入.
SELECT * FROM openrowset('sqloledb','REMOTE_SERVER_NAME';'SA';'',DB_NAME.dbo.TABLE_NAME)
commit transaction没锁住远程照样能插入.
在第一個連接中執行以下語句
begin tranSELECT * FROM openrowset('sqloledb','REMOTE_SERVER_NAME';'SA';'',DB_NAME.dbo.TABLE_NAME), holdlock -holdlock人為加鎖waitfor delay '00:00:30' --等待30秒commit tran
SELECT * FROM openrowset('sqloledb','REMOTE_SERVER_NAME';'SA';'',DB_NAME.dbo.TABLE_NAME )holdlock
不行
SELECT * FROM openrowset('sqloledb','REMOTE_SERVER_NAME';'SA';'',DB_NAME.dbo.TABLE_NAME )TABLOCKX
可以