INSERT
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