Forum Discussion

HELJEEVE's avatar
HELJEEVE
Copper Contributor
Oct 27, 2023

CONCURRENCY IN SQLSERVER

MY BETOPTIONS TABLE DESIGN ID COUNT 1 100 2 200 3 45 4 2 LIKE THIS   MY STORED PROCEDURE IS LIKE THIS CREATE PROCEDURE BUYLOTTOGAME BEGIN TRANS SELECT @COUNT=COUNT FROM TABLENAME WIT...
olafhelper's avatar
olafhelper
Bronze Contributor

 

HELJEEVE wrote:
here concurrent transaction will trying to update the same row

HELJEEVE , that will never cause a deadlock, only a wait until the transaction finished; and for a single (same) row you don't need a complexe transaction handle, implicit transactions will be quite enough.

HELJEEVE's avatar
HELJEEVE
Copper Contributor
Nov 07, 2023
SO WHY FOR UPDATE OF CLAUSE IS USED IN ORACLE

Resources