[Дрег Ден]

Поздравляю всех с Новым Годом!

DECLARE @id_memoryregionNew uniqueidentifier
DECLARE @curYearNew int
SET @id_memoryregionNew = newid()
SET @curYearNew = YEAR(GetDate())

UPDATE
MemoryRegions
SET
stateCompleted = 1
WHERE
stateCompleted = 0

UPDATE
Constants
SET
curYear = @curYearNew

INSERT IGNORE INTO MemoryRegions
(id_memoryregion,
year)
VALUES
(@id_memoryregionNew,
@curYearNew)

SELECT @id_memoryregionNew