列名或提供的值数量与表定义不匹配

问题描述

在 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

这篇关于列名或提供的值数量与表定义不匹配的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持跟版网！