Microsoft Studio "script table like" for INSERT for bad syntax

Question

I have a table in a database that looks like

I want to insert a new entry. So I right-click on my table, hover over the "script table as" and select the "INSERT to" option

When I do it, I get it

My question is what is wrong with this syntax? I seem to get an error before trying to add something. When I hover over the red lines, I get a message that

'Invalid syntax near <'

&

'varchar is not a recognized built-in function name

I assumed that I would replace the second part with my data values. But I'm not sure.

Answer 1

.

INSERT INTO tab_name(First_Name, Last_Name, ...)
VALUES ('John', 'Smith', ...);

<col_name, datatype> .

---

Use Templates in SQL Server Management Studio .

Query → Specify Values for Template Parameters

CTRL + SHIFT + M