Query execution

Refer

http://forums.asp.net/p/1923579/5458581.aspx?Re+Insert+and+Update+in+one+query

http://stackoverflow.com/questions/108403/solutions-for-insert-or-update-on-sql-server

http://blog.sqlauthority.com/2010/06/08/sql-server-merge-operations-insert-update-delete-in-single-execution/