SQL Server error: Column name or number of supplied values does not match table definition

» sql » SQL Server error: Column name or number of supplied values does not match table definition

By : JanKoro

Date : November 23 2020, 01:01 AM

I wish did fix the issue. It is clearly said by exception - that columns number or order of values selected doesn't match columns defined in ArchivioErogazioni.
It is almost always better to insert using explicit list of columns to insert to. This can prevent you from many "logical" errors too.

code :

dbo.SomeTable(Name_First nvarchar(20), Name_Last nvarchar(20))

insert into dbo.SomeTable
select Name_Last, Name_First
from Some_Other_Table_Or_Subquery

insert into dbo.SomeTable (Name_Last, Name_First)
select Name_Last, Name_First
from Some_Other_Table_Or_Subquery

Share :

SQL Server Insert Error: Column name or number of supplied values does not match table definition

By : Ray Kenneth Lo Cerbo

Date : March 29 2020, 07:55 AM

Hope that helps Double-check the primary key (I assume if your product ID) of your Products table if it's value is set to auto increment (Identity Specification > Is Identity = true)

Column name or number of supplied values does not match table definition from SQL server

By : Graham Hickson

Date : March 29 2020, 07:55 AM

I wish did fix the issue. You're not inserting anything into ID column of Sales. You need to specify it in your query:

code :

insert into Sales values(
   SomeIDHere,
   (select TOP 1 ClientID from Client Order by NEWID()),
   (select @prodNum),
   (select @quantity),
   ((select @quantity)*(select TOP 1 Price from Product where ProductNumber = @prodNum)),
  DEFAULT
  )

CREATE TABLE Sales (
ID INT IDENTITY(1,1) NOT NULL  ,
ClientID INT REFERENCES Client(ClientID),
ProductNumber CHAR(10)  REFERENCES Product(ProductNumber),
Quantity INT NOT NULL,
Price FLOAT NOT NULL ,
Date TIMESTAMP NOT NULL,
PRIMARY KEY ( ID ) 
);

insert into Sales (ClientID, ProductNumber, Quantity, Price, [Date])
values(
   (select TOP 1 ClientID from Client Order by NEWID()),
   (select @prodNum),
   (select @quantity),
   ((select @quantity)*(select TOP 1 Price from Product where ProductNumber = @prodNum)),
  DEFAULT
  )

Insert/Update DataTable to SQL Server ERROR:Column name or number of supplied values does not match table definition

By : Triangle

Date : March 29 2020, 07:55 AM

With these it helps Change your Insert statement to this if you don't want to add Countries:

code :

INSERT INTO People(Id, Email, Name) VALUES(p2.ID, p2.Name, p2.Email);

CREATE TYPE [dbo].[PeopleType] AS TABLE(
  [ID] [varchar](10) NOT NULL,
  [Name][varchar](50) NULL,
  [Email][varchar](50) NULL,
  [Country][varchar](50) NULL
)

INSERT VALUES(p2.ID, p2.Name, p2.Email, p2.Country);

INSERT (Id, Email, Name) VALUES(p2.ID, p2.Name, p2.Email);

Column name or number of supplied values does not match table definition using sql server

By : user2768522

Date : March 29 2020, 07:55 AM

hop of those help? Probably your Employee table has more than three columns but you supplied here only three.
For resolution, you should mention all the columns value or mention the name of these columns in the insert statement. The second solution will work if the rest columns can accept null values. For Example

code :

 Insert into Employee (Name, City, Address) values (@Name, @City, @Address)

SQL server - Msg 213 - Insert Error: Column name or number of supplied values does not match table definition

By : user3913372

Date : March 29 2020, 07:55 AM

this one helps. In SQL server, I am trying to insert values from one table to another by using the below query : , Is one of the columns an IDENTITY column?