Why does this not work

Hi There,
Just testing a database and was wondering why this simple code does not work,

USE [totalglassdb]
INSERT INTO [Test1] , [Test2]
VALUES ["Steve"] , ["Wilson"];

Thanks for your help.

You do not say in which table the values need to be added (I assume Test1 and Test2 are fieldnames?)
insert into Tablename([Test1],[Test2])
values( "Steve", "Wilson")

see INSERT (Transact-SQL) - SQL Server | Microsoft Learn

1 Like

For SQL Server, double quotes are not normally used for literals, only for identifiers (such as column names). Therefore:

INSERT INTO dbo.your_table_name ( [Test1], [Test2] )
VALUES ('Steve', 'Wilson')
1 Like

Thanks Scott, That worked.

Best Regards,