1302
Whoops (thumbsnap.com)
(page 2) 34 comments
sorted by: hot top controversial new old
[-] argo_yamato@lemm.ee 6 points 1 year ago

Had something like that happen to a local dev database (thankfully). A dev next me blurts out "how to I rollback an update in SQL server"? He was used to Oracle and how easy it is to rollback something. Had to explain that commit just happens in SQL server regardless of whether or not you put that commit line in.

[-] neosheo@discuss.tchncs.de 4 points 1 year ago

I'm dying lol

wasnt halloween last week. stop scarin me

[-] r00ty@kbin.life 3 points 1 year ago

For MS-SQL. If it is production, it has a full transaction log, right? I mean I know for development use I turn that off, but for live data you want that on. You should be able to roll back to any point since the last time it was truncated. Or right before hitting return to whatever level of accuracy you're comfortable with.

[-] jabberati@social.anoxinon.de 1 points 1 year ago

BEGIN TRANSACTION is your friend

load more comments
view more: ‹ prev next ›
this post was submitted on 06 Nov 2023
1302 points (98.7% liked)

Programmer Humor

32581 readers
988 users here now

Post funny things about programming here! (Or just rant about your favourite programming language.)

Rules:

founded 5 years ago
MODERATORS