Printer-friendly versionSend to friendPDF version

When you try to INSERT values from one table to another table of same structure, you may see the following error in SQL Server 2005:

"Column name or number of supplied values
does not match table definition"

Majority of time this is due to a simple mistake of not having the same column name or column definition as the other table. Carefully check the table structure and the problem will be resolved.