Re: is there any way to know how many rows affected by a sql query?
From: Ed prochak <ed.prochak_at_alltel.com>
Date: 13 May 2002 13:03:23 -0700
Message-ID: <e51b160.0205131203.38cc6817_at_posting.google.com>
Date: 13 May 2002 13:03:23 -0700
Message-ID: <e51b160.0205131203.38cc6817_at_posting.google.com>
sohelcsc_at_yahoo.com (Leader) wrote in message news:<b1a93c73.0205130002.4e18e3ab_at_posting.google.com>...
> HI All,
>
> I want to know is there any way to know how many rows affected by a
> sql. one Sql i need for that.
>
>
> thanks
> hoque
Why won't
SELECT COUNT(*)
FROM <your tables>
WHERE <same criteria as your statement>
;
tell you the answer? Received on Mon May 13 2002 - 22:03:23 CEST