Jaroslaw is a user on mastodon.social. You can follow them or interact with them if you have an account anywhere in the fediverse. If you don't, you can sign up here.

PLEASE HELP!

I'm using a Microsoft SQL database. I've found two incorrect values, which I'd like to replace.

Database is called mdpPrinters
Table is dbo.PrintersAuditsDelta

Columns are TotalPages, and TotalPagesColor

I have a unique identifier, PrinterAuditID 238018

I haven't messed with databases in a very long time and I have no idea how to "set" these values.

PLEASE HELP!

@electrotamitha use mdpPrinters
update dbo.PrintersAuditsDelta set TotalPages = VALUE1, TotalPagesColor = VALUE2 where PrinterAuditID = 238018