Re: Row count from stored procedure

Justin,

You could use the GET DIAGNOSTICS statement. The parameter you want is,
IIRC, ROW_COUNT.

HTH,

Luis Rodriguez

--



On Tue, 12 Nov 2019 at 11:30, Justin Taylor <JUSTIN@xxxxxxxxxxxxx> wrote:

If I run an UPDATE statement via Run SQL Scripts, it gives a message
indicating the number of rows affected. I have a SQL stored procedure

that

does an UPDATE, but it does not give the row count.

Is there some way to get the row count?

TIA
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com