I have an issue while doing a migration to SQL Server.

This is original query statement.

SET @V_GI_SEQ = CAST(NEXT VALUE FOR [DBO].[SEQ_GI_SEQ] AS varchar);

but this happened.

메시지 102, 수준 15, 상태 1, 프로시저 SPC_LGT_PDA_INCOMING_INSPECTION_U, 줄 210 [배치 시작 줄 7]
Incorrect syntax near ‘VALUE’.

so I found this example from ms documents.

SET @myvar2 = NEXT VALUE FOR Test.CountBy1;

But it doesn’t work yet.
Is there any solutions for this?
Help me please.