SQL Server: Best way to Update row if exists, Insert if not (weblogs.sqlteam.com)
submitted by
spirit1(3160) 4 years, 6 months ago
This question pops up a lot everywhere and it's a common business requirement and until SQL Server 2008 doesn't come out with it's MERGE statement that will do that in one go we're stuck with 2 ways of achieving this. The biggest problem with every update/insert (upsert for those who haven't heard the term yet) is locking. read more...
|category: Database
|Views: 114
tags:
Locks Insert Update 2005 SQLServer another
Everyones tags:
Your Tags: