Column name or number of supplied values does not match table definition
sql, sql-server, sql-server-2005, t-sql
Solution
They don't have the same structure... I can guarantee they are different
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
Problem
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 ``` I am getting the following error: 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.