Why does this not work

Transact-SQL
1

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

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

Thanks for your help.

2

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
3

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
4

Thanks Scott, That worked.

Best Regards,

Steve.