Posted by Alex Kuznetsov on 02/07/07 20:31

On Feb 6, 7:28 am, "Bart op de grote markt" <bartwar...@freegates.be>
wrote:
> Hello
>
> I used to work in a Sybase database environment. When I had to insert/
> update records in the database, I always used "insert on existing
> update", in this way, you didn't have to check whether a record
> already existed (avoid errors) and you were always sure that after
> running the scripts, the last version was in the database.
>
> Now I'm looking for the same functionality in MS SQL Server, asked a
> few people, but nobody knows about such an option.
> Does anybody here knows the SQL Server counterpart of "insert on
> existing skip/update"? If this doesn't exist, this is a minus for
> MS ;).
>
> Greetz,
>
> Bart

Also look up "Mimicking MERGE Statement in SQL Server 2005 ":

http://sqlserver-tips.blogspot.com/2006/09/mimicking-merge-statement-in-sql.html

[Back to original message]