I wrote a VB.NET application that simply do some inserts. Issue I'm running into is that we have old and new databases for this off the shelf ERP software. The new databases have a few extra fields that does not exists in the old database.
Is it possible to use the same insert and insert the field if it exists and not insert if it doesn't?
insert into master_item(id, description, bin_id)
values('99232', '3.4x3.3 ALX 20032', '234')
The above example, the "bin_id" does not exists in the old database. I'm using the vb.net program to insert items into each database via a loop. I would hate to create 2 separate query strings for this. Could it be modify so that one query string would work?