• DECLARE @i AS INT = 100,@msg AS VARCHAR(5)= '11',@Date AS DATE=GETDATE()

    will generate error "Cannot assign a default value to a local variable."