title: UPDATE if exists else INSERT in SQL Server 2008
body: <p>I want to know how can I use <code>UPSERT</code> or in other words <code>UPDATE if records exists Else enter new record</code> operation in SQL Server using one statement?</p>
  
  <p>This example shows the ways of achieving this in Oracle <a href="https://stackoverflow.com/questions/4015199/oracle-sql-update-if-exists-else-insert">Here</a>
  But it uses <code>Dual</code> table for it which doesn't exists in <code>SQL Server</code>.</p>
  
  <p>So, Any SQL Server Alternatives <em>(No Stored procedures)</em> please ?</p>