INSERT INTO [dbo].[P4YS_Country] ([Country])VALUES (United States,Anguilla,Antigua,Austrialia,);
Country is a nvarchar(50)
I have tried this:
INSERT INTO [dbo].[P4YS_Country] ([Country])VALUES ('United States','Anguilla','Antigua','Austrialia')Now I get:System.Data.SqlClient.SqlException: There are fewer columns in the INSERT statement than values specified in the VALUES clause. The number of values in the VALUES clause must match the number of columns specified in the INSERT statement.I tried whem witout single quotes and then get the error message on Anguilla. The first column in the table is ID as int, set at primary key with identity set to Yes.
Here is the script to create my table:
SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCREATE TABLE [dbo].[P4YS_Country]([ID] [int] IDENTITY(1,1) NOT NULL,[Country] [nvarchar](50) NOT NULL,CONSTRAINT [PK_P4YS_Country] PRIMARY KEY CLUSTERED ([ID] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]Table created witout a problem.