Исходный код вики Поиск блокировок

Версия 1.1 от Alexandr Fokin на 2020/10/29 19:00

version	line-number	content
1.1	1
	2	https://ausevich.ru/subd/poluchenie-informatsii-o-tekushchikh-ispolnyaemykh-zaprosakh/
	3
	4	{{code language="sql"}}
	5
	6	DECLARE @key INT = 12
	7	DECLARE @msg NVARCHAR(MAX) = 'L2'
	8
	9	BEGIN TRAN
	10	IF EXISTS (
	11	SELECT *
	12	FROM DBO.LOG2ENTITY WITH (UPDLOCK, SERIALIZABLE)
	13	WHERE ID = @key
	14	)
	15	BEGIN
	16	UPDATE DBO.LOG2ENTITY
	17	SET
	18	Message = @msg
	19	WHERE ID =@key
	20	END
	21	ELSE
	22	BEGIN
	23	INSERT INTO DBO.LOG2ENTITY (Message)
	24	VALUES (@msg)
	25	END
	26	COMMIT TRAN
	27
	28	{{/code}}

Приложения