Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Definition Mismatch

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-07-15 : 20:40:43
Salko writes "when i use INSERT INTO for an exisiting table my source_table and target_table are identical except for one column (IDcolumn).
I add this column to target_table when first creating it with SELECT INTO. when INSERT_INTO tries to update my target_table next time around of course it has a definition mismatch error. is there a way i can force it to ignore this IDcolumn when INSERT INTO is executing. i need it done this way because IDcolumn is updated at a later time."
   

- Advertisement -