I have a working knowledge of SQL Server, but I am not an expert. I wonder if you could give me reasons for a strange observed behavior.
I do a simple insert on a table as shown in the codebase below. Notice the Archived is to be set to one. When I run the query however, and then do a select to see the result, the Archived is set to 0 in the database.
What are some possbile reasons for this?
INSERT INTO PG