Very basic SQL but I'm stuck?

Question

My question says "Write an UPDATE statement that modified the InvoiceCopy Table. Chance the PaymentDate to today's date and the PaymentTotal to the balance due for each invoice with a balance due."

And my code is as given.


"UPDATE InvoiceCopy
SET PaymentDate = GETDATE()
WHERE PaymentTotal <> 0"

It's saying 103 rows affected, but it doesn't display any of them. Is it supposed to do that?

Answer 1

Yes that is correct.

Answer 2

That is correct. An action query (INSERT, UPDATE or DELETE) does not normally output anything to the user except possibly (depending on the DBMS) the number of rows affected (if any). If you wanted an echo back of the updated row, you could only do so either by means of a trigger (only recommended if you create the trigger just before the action query and drop it immediately afterwards) or a script that pairs the action query with an appropriate SELECT.

Answer 3

if you need to display rows you need another sql statement



"SELECT * FROM InvoiceCopy WHERE PaymentTotal <> 0""

Answer 4

The query is correct. It updates the rows. If you want to view the changes, then you will need to SELECT them.



Good Luck!

If you need further assistance/advice, feel free to contact me.

Answer 5

It won't display the records. All it will do is what it did, telling you the number of records affected.

Answer 6

mmmm