MSSQL - Fix Error - Incorrect syntax near '='

Watch this example on YouTube


To fix it replace
Declare @test int = 0
if(@test == 0)
begin
    print 'Zero'
end

with
Declare @test int = 0
if(@test = 0)
begin
    print 'Zero'
end