SQL: If Exists Update Else Insert - Jeremiah Clark's Blog - Site Home - MSDN Blogs

This is a pretty common situation that comes up when performing database operations. A stored procedure is called and the data needs to be updated if it already exists and inserted if it does not. If we refer to the Books Online documentation, it gives ex

blogs.msdn.com