sqlserver variable not define

[theonewu]

declare @curr date=getdate();
declare @y int=2025;

IF @curr < DATEFROMPARTS(YEAR(@curr), 6, 10)
BEGIN
    SET @y = YEAR(@curr) - 1
END
ELSE
BEGIN
    SET @y = YEAR(@curr)
END

@curr not define

[lovasoa]

Variables are handled by SQLPage itself, you cannot use ms sql variables directly in your SQLPage files. See https://sql-page.com/extensions-to-sql