Need help with automating the update of a database in sql

[futbwal15]

does anyone out there know how to code sql into bringing out a value from a list that DOESNT exist in the table. It sounds simple to do with a "doesnt equal to" but this isnt the answer i am looking for.

for example, you run the query and if itmes exist, then they are updated, if an item doesnt exist, then it is created and inserted into the table.

Does anyone have a basic idea of how to do this?

 

[AlexCuse]

Are you trying to load a set of records or one at a time?

Here is something basic.

if exists (select * from SomeTable where PK_Col = somePK)

begin

update a
set a.someValue = b.someValue
from SomeTable a inner join SomeOtherTable b 
on a.PK_Col = b.PK_Col

end

else

begin

insert into SomeTable (PK_Col, someValue)
select PK_Col, someValue from SomeOtherTable

end

A google search for 'UPSERT SQL Server' should help you out as well.

Good Luck,

Alex


Ignorance of certain subjects is a great part of wisdom