Michael Peppler
Sybase Consulting
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
Sybase on Linux FAQ
Sybperl FAQ
Michael Peppler's resume

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.
> --------------------------------------------------------------------