BEGIN TRANSACTION;
	SELECT * FROM Card
	UPDATE Card SET number = 5 WHERE Card_Id = 3
	WAITFOR DELAY '00:00:05'
	ROLLBACK;
	SELECT * FROM Card
	SELECT * FROM sys.dm_tran_locks;
--COMMIT
go

/*BEGIN TRANSACTION;
	SELECT * FROM Card
	UPDATE Card SET number = 90 WHERE Card_Id = 3
	--WAITFOR DELAY '00:00:05'
	SELECT * FROM Card
	SELECT * FROM sys.dm_tran_locks;
COMMIT*/

/*--SET TRANSACTION ISOLATION LEVEL REPEATABLE READ
BEGIN TRANSACTION;
	SELECT * FROM Card WHERE Card_Id in (1, 2)
	WAITFOR DELAY '00:00:05'
	SELECT * FROM Card WHERE Card_Id in (1, 2)
	ROLLBACK
SELECT * FROM Card*/


/*SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
BEGIN TRANSACTION;
	SELECT * FROM Card WHERE Card_Id in (1,2)
	WAITFOR DELAY '00:00:05'
	SELECT * FROM Card WHERE Card_Id in (1,2)
	ROLLBACK
SELECT * FROM Card*/