Исходный код вики INSERT or UPDATE | NoConcurrent

Версия 5.5 от Alexandr Fokin на 2022/01/03 14:54

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

Приложения