|
|
sybperl-l Archive
Up Prev Next
From: Murali Kumar <mkumar at nih dot gov>
Subject: Re: Query
Date: Sep 25 2000 2:09PM
Amit Agarwal wrote:
> Dear all,
>
> 1. If I execute a query like "select * from..." and would like to
> store the number of rows affected in a variable, how could I go about
> doing that.
>
The #rows affected is available through the system variable @@rowcount
>
> 2. If I execute a stored proc like "exec sp_helptext ...." from
> syberl, how can i capture the output to a flat file.
>
> Any help would be greatly appreciated.
>
> Regards.
>
> --------------------------------------------------------------------
> The information transmitted is intended only for the person
> or entity to which it is addressed and may contain confidential
> and/or privileged material. Any review, retransmission,
> dissemination or other use of, or taking of any action in reliance
> upon, this information by persons or entities other than the
> intended recipient is prohibited. If you received this in error,
> please contact the sender and delete the material from any
> computer.
> --------------------------------------------------------------------
|
