I am working on some code in vb.net that will run periodically to update a sql2005 database table.
table structure is very simple.
tblserver
Servername (Keyfield)
item1
item2
etc.
anyway. I need to run an update to the database and insert records if the server does not exists in the table
I can do a loop
that seems pretty inefficent, given that I would have to check each of the 400 + servers against the current databaseCode:for each input server if input server = tbleserver.servername tblserver.servername.next you get the point.
Any recommendations?




Reply With Quote