BEGIN TRAN; SELECT 0 FROM [Table] WITH(TABLOCK,HOLDLOCK,XLOCK); --Ton travail COMMIT TRAN;
DECLARE @Void TABLE (void int); BEGIN TRAN; INSERT INTO @Void SELECT DISTINCT 0 FROM [Table] WITH(TABLOCK,HOLDLOCK,XLOCK); --Ton travail COMMIT TRAN;
DECLARE @Void TABLE (void int); BEGIN TRAN; INSERT INTO @Void SELECT DISTINCT 0 FROM [Table1] WITH(ROWLOCK,HOLDLOCK,XLOCK) WHERE ID = @ID; INSERT INTO @Void SELECT DISTINCT 0 FROM [Table2] WITH(ROWLOCK,HOLDLOCK,XLOCK) WHERE ID_Table_1 = @ID; --Ton travail COMMIT TRAN;
DECLARE @Void TABLE (void int); BEGIN TRAN; INSERT INTO @Void SELECT DISTINCT 0 FROM [Table] WITH(TABLOCK,HOLDLOCK,UPDLOCK); --Ton travail COMMIT TRAN;
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre question