MSSQL - how to fix error Cannot assign a default value to a local variable.

Watch on Youtube



When executing code like

Declare @Test int  = 1

I am getting error
Cannot assign a default value to a local variable.

This is because I am using old version of MSSQL (9.5)
To fix it - download the newest version.