列名或提供的值数量与表定义不匹配
在 SQL Server 中，我尝试使用以下查询将值从一个表插入到另一个表:
In the SQL Server, I am trying to insert values from one table to another by using the below query:
delete from tblTable1
insert into tblTable1 select * from tblTable1_Link
我收到以下错误:
列名或提供的值数量与表定义不匹配.
Column name or number of supplied values does not match table definition.
我确信这两个表具有相同的结构、相同的列名和相同的数据类型.
I am sure that both the tables have the same structure, same column names and same data types.
推荐答案
它们的结构不一样...我可以保证它们是不同的
They don't have the same structure... I can guarantee they are different
我知道你已经创建了它... 数据库中已经有一个名为 'tbltable1' 的对象
I know you've already created it... There is already an object named ‘tbltable1’ in the database
您可能想要的是这个(这也解决了您的其他问题):
What you may want is this (which also fixes your other issue):
Drop table tblTable1
select * into tblTable1 from tblTable1_Link
相关文章