I have the same issue, and i solved it by removing the semicolon (;)
DECLARE @common_name VARCHAR(400) = 'Testface' INSERT INTO dbo.table (ID, Name) VALUES (3, @common_name) INSERT INTO dbo.table (ID, Name) VALUES (3, @common_name)