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

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

author	version	line-number	content
		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}}

Приложения