Tamitha is a user on octodon.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!
@Jaroslaw Ah! That worked, thank you so much!
@electrotamitha no problem. cheers!
@electrotamitha update TABLE set COLUMN1 = VALUE1, COLUMN2 = VALUE2, etc... where COLUMN = VALUE
@starbreaker Thanks!
@electrotamitha Got what you needed?
@starbreaker Yup, thank you!
@electrotamitha use mdpPrinters
update dbo.PrintersAuditsDelta set TotalPages = VALUE1, TotalPagesColor = VALUE2 where PrinterAuditID = 238018