22,209
社区成员
发帖
与我相关
我的任务
分享
CREATE PROCEDURE [dbo].[ToRecord9] @cSOCode VARCHAR(10)
AS
select * from table1 (with TABLOCKX)
BEGIN TRY
SET xact_abort ON
BEGIN TRAN
UPDATE table1 SET F1=0----上面那个锁不影响这里的更新操作吗?从目前事实上来看好像毫无影响,但这从理论上好像解释不通啊
COMMIT TRAN
END TRY
BEGIN CATCH
PRINT CAST(@@TRANCOUNT AS CHAR(10)) + '捕获错误'
IF (@@TRANCOUNT > 0)
PRINT ERROR_MESSAGE()
ROLLBACK TRAN
END CATCH