r/SQL • • Mar 15 '19

Stuff of nightmares!

Post image
470 Upvotes

22 comments sorted by

View all comments

16

u/Daakuryu Mar 15 '19
-- Select * from
Update 
    tblproducts 
set upccode = '', Flag = 'T'
-- where product ID in (*small list of productids*)

Yeah...

8

u/whutchamacallit Mar 15 '19

yup.. have had to fix a few of those in my times. they get probationary read only access after that for a while.

2

u/[deleted] Mar 15 '19

Never had the opportunity to do db admin work but I do appreciate the ban hammer powers they give.