Sean Lange (11/9/2012)

---

Luis Cazares (11/9/2012)

---

I'm a little more considerate than Sean and will tell you where to start. All these articles are at your disposal just by pressing F1 in SSMS.

Stored Procedures: http://msdn.microsoft.com/en-us/library/ms190782(v=sql.105).aspx

"New" way of doing what is expected:

MERGE: http://msdn.microsoft.com/en-us/library/bb510625(v=sql.100).aspx

EDIT: You don't need a trigger, but in your script you have a way to check if the row "exists"

If I came across as inconsiderate I apologize. Certainly not my intention.