sql server - SQL: UPDATE if not exists, else DELETE - Stack Overflow

SQL: UPDATE if not exists, else DELETE up vote 3 down vote favorite I'm currently trying to write a script that will change a user's role to another, without creating duplicates in a SQL Server database. For example: User_ID Role_ID ----- A X Y Users may

stackoverflow.com