Исходный код вики Insert or Update

Версия 3.1 от Alexandr Fokin на 2020/03/21 22:19

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

Приложения