I’m new to TOAD; I’ve used SQL Management Studio before. In Management Studio, if I run multiple update statements, I get a message for each update saying how many rows were affected. In Toad, the message has one message saying how many records were updated in total. Is there a way to get Toad to list the number of records updated for each update statement? I need to know that each update statement worked. If one of them affected 0 rows, I need to know that, not have that information get lost in a total. Thanks.
Try !
Turn on Message / Text Output after your run and see what you get…
I am always toggling this feature to see the messages.
Hank Freeman
Senior Systems, Database/Data Warehouse Architect
678.414.0090 my cell Primary
Try !
Turn on Message / Text Output after your run and see what you get…
I am always toggling this feature to see the messages.
Hank Freeman
Senior Systems, Database/Data Warehouse Architect
678.414.0090 my cell Primary
Try !
Turn on Message / Text Output after your run and see what you get…
I am always toggling this feature to see the messages.
Hank Freeman
Senior Systems, Database/Data Warehouse Architect
678.414.0090 my cell Primary
It doesn’t help. I have the exact same problem - and while turning on text messages makes the message easier to read, it does not change the message.
However - if you put “GO” between the statements, Toad will generate a new message (+ count) for each statement, thereby yielding the record count for each.
No count is however given for SELECT-queries.
It would be a much welcomed improvement if Toad were able to show records affected messages in the same way as SSMS.
Regards /Jens
That did it! Thanks.