在不使用存储过程的情况下在SQL Server 2005上插入/更新

I'm trying to do the classic Insert/Update scenario where I need to update existing rows in a database or insert them if they are not there.I'm trying to do the classic Insert/Update scen