MSSQL Error code 213 Column name or number of supplied values does not match table definition

less than 1 minute read

When dealing with ms-sql, there are times when you encounter the following errors…

[S0001][213] Column name or number of supplied values does not match table definition.

Of course, it is an error that occurs when the number of table columns is not correct. However it can sometiems be a error caused by a table trigger!

Be careful, after modify table! You shoud modify table trigger after alter table column especially add and delete.

Tags:

Categories:

Updated:

Leave a comment