返回首页

您好,
请告诉我,如何锁定/ SQL数据库的记录行,让其他人无法读取该记录时IAM更新行/ record...please帮我...:7962316 |会员

回答

评论会员:游客 时间:2012/02/06
阅读以下内容:imgsrc={A1}]
AswinKrishnan
评论会员:游客 时间:2012/02/06
设为交易隔绝等级codeprelang="SQL"spanclass="code-keyword"USE/spanAdventureWorks2008R2;spanclass="code-keyword"GO/spanspanclass="code-keyword"SET/spanspanclass="code-keyword"TRANSACTION/spanISOLATIONLEVELREPEATABLEREAD;spanclass="code-keyword"GO/spanspanclass="code-keyword"BEGIN/spanTRANSACTION;spanclass="code-keyword"GO/spanspanclass="code-keyword"SELECT/span*spanclass="code-keyword"FROM/spanHumanResources.EmployeePayHistory;spanclass="code-keyword"GO/spanspanclass="code-keyword"SELECT/span*spanclass="code-keyword"FROM/spanHumanResources.Department;spanclass="code-keyword"GO/spanspanclass="code-keyword"COMMIT/spanTRANSACTION;spanclass="code-keyword"GO/span/pre/code阅读更多@MSDN上:{A2}