(Mark Callaghan) When incrementing a table that manages a count are you an optimist or a pessimist? If the row is likely to exist, you should first try to update it and do an insert when the update fails. Otherwise, use insert … on duplicate key udpate.
Read More - Register for Free Membership
SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help