SQL Update Statement can go crazy!!!

sql-logo
We had a production issue today and to rectify it i need to update some  records in production. As I dont have access to production database , I  raised a help desk ticket with the SQL statements. I have to provide two statement which are as follows [1] Update the “active”  column value to 1 and reference id column to NULL for for ONE  payer (example payer with primary Key : 100). [2] Mark the “active” column to 0 and referenced id column to 100 (referencing payer with... more →
Posted in: Programming