Inserting multiple values into a temporary table, SQL Server

Question

I am using Microsoft SQL Server Management Studio, I am trying to run the following query to input values into a temporary table to use later:

CREATE TABLE #temptable
(colnumber varchar(15), dispcode varchar(10))

INSERT INTO #temptable (colnumber, dispcode)
VALUES 
('col5', '811'),
('col6', '817'),
('col7', '823'),
('col8', '825');

When running I get the following error:

Msg 102, Level 15, State 1, Line 50
Incorrect syntax near ','.

Which points to the line "('col5', '811'),"

Could anyone help me identify the problem here?

Answer 1

For SQL Server version <2008 use this:

INSERT INTO #temptable (colnumber, dispcode)
SELECT 'col5', '811'
UNION ALL SELECT 'col6', '817'
UNION ALL SELECT 'col7', '823'
UNION ALL SELECT 'col8', '825'