Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Check rowcount of last run select query

3 posts in General Discussion Last posting was on 2009-07-25 04:52:08.0Z
weird0 Posted on 2009-07-23 09:48:12.0Z
From: weird0 <amirediwan@gmail.com>
Newsgroups: sybase.public.ase.general
Subject: Check rowcount of last run select query
Date: Thu, 23 Jul 2009 02:48:12 -0700 (PDT)
Organization: http://groups.google.com
Lines: 6
Message-ID: <cce3df4f-8b66-4609-b333-21026f3a2ff0@f20g2000prn.googlegroups.com>
NNTP-Posting-Host: 202.125.129.123
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
X-Trace: posting.google.com 1248342493 24692 127.0.0.1 (23 Jul 2009 09:48:13 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Thu, 23 Jul 2009 09:48:13 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: f20g2000prn.googlegroups.com; posting-host=202.125.129.123; posting-account=pMovMQoAAAAgsDoqEc2W8ndm3iu6gcuC
User-Agent: G2/1.0
X-HTTP-Via: 1.0 IPROXY-KCI
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.2; SV1; .NET CLR 1.1.4322; .NET CLR 2.0.50727),gzip(gfe),gzip(gfe)
Path: forums-1-dub!forums-master!newssvr.sybase.com!news-sj-1.sprintlink.net!news-peer1.sprintlink.net!nntp1.phx1.gblx.net!nntp.gblx.net!nntp.gblx.net!border2.nntp.dca.giganews.com!nntp.giganews.com!postnews.google.com!f20g2000prn.googlegroups.com!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28028
Article PK: 77275

How do i check the rowcount of the last ran select query in my
procedure...?

Oracle has something like SQL%ROWCOUNT or SQL%ROWNUM to implement it.

How do I implement that in Sybase ?


mpeppler@peppler.org [Team Sybase] Posted on 2009-07-23 10:19:52.0Z
From: "mpeppler@peppler.org [Team Sybase]" <michael.peppler@gmail.com>
Newsgroups: sybase.public.ase.general
Subject: Re: Check rowcount of last run select query
Date: Thu, 23 Jul 2009 03:19:52 -0700 (PDT)
Organization: http://groups.google.com
Lines: 11
Message-ID: <6b51b4d3-56a6-4d66-a825-f92fe0b61b3e@h18g2000yqj.googlegroups.com>
References: <cce3df4f-8b66-4609-b333-21026f3a2ff0@f20g2000prn.googlegroups.com>
NNTP-Posting-Host: 170.148.198.156
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
X-Trace: posting.google.com 1248344392 15385 127.0.0.1 (23 Jul 2009 10:19:52 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Thu, 23 Jul 2009 10:19:52 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: h18g2000yqj.googlegroups.com; posting-host=170.148.198.156; posting-account=9rHMzAoAAADtzToS8d2WKVGlkISAvPdk
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.1.1) Gecko/20090715 Firefox/3.5.1,gzip(gfe),gzip(gfe)
Path: forums-1-dub!forums-master!newssvr.sybase.com!news-sj-1.sprintlink.net!news-peer1.sprintlink.net!nntp1.phx1.gblx.net!nntp.gblx.net!nntp.gblx.net!border2.nntp.dca.giganews.com!nntp.giganews.com!postnews.google.com!h18g2000yqj.googlegroups.com!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28029
Article PK: 77278


On Jul 23, 11:48 am, weird0 <amiredi...@gmail.com> wrote:
> How do i check the rowcount of the last ran select query in my
> procedure...?
>
> Oracle has something like SQL%ROWCOUNT or SQL%ROWNUM to implement it.
>
> How do I implement that in Sybase ?

select @@rowcount

Michael


weird0 Posted on 2009-07-25 04:52:08.0Z
From: weird0 <amirediwan@gmail.com>
Newsgroups: sybase.public.ase.general
Subject: Re: Check rowcount of last run select query
Date: Fri, 24 Jul 2009 21:52:08 -0700 (PDT)
Organization: http://groups.google.com
Lines: 16
Message-ID: <90521adc-075f-4be9-8eed-26b3742d0f09@d15g2000prc.googlegroups.com>
References: <cce3df4f-8b66-4609-b333-21026f3a2ff0@f20g2000prn.googlegroups.com> <6b51b4d3-56a6-4d66-a825-f92fe0b61b3e@h18g2000yqj.googlegroups.com>
NNTP-Posting-Host: 202.125.129.123
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
X-Trace: posting.google.com 1248497528 17205 127.0.0.1 (25 Jul 2009 04:52:08 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Sat, 25 Jul 2009 04:52:08 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: d15g2000prc.googlegroups.com; posting-host=202.125.129.123; posting-account=pMovMQoAAAAgsDoqEc2W8ndm3iu6gcuC
User-Agent: G2/1.0
X-HTTP-Via: 1.1 IPROXY-KCI
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1),gzip(gfe),gzip(gfe)
Path: forums-1-dub!forums-master!newssvr.sybase.com!news-sj-1.sprintlink.net!news-peer1.sprintlink.net!nntp1.phx1.gblx.net!nntp.gblx.net!nntp.gblx.net!newsfeed.news2me.com!nx01.iad01.newshosting.com!newshosting.com!69.16.185.11.MISMATCH!npeer01.iad.highwinds-media.com!news.highwinds-media.com!feed-me.highwinds-media.com!postnews.google.com!d15g2000prc.googlegroups.com!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28047
Article PK: 77294

On Jul 23, 3:19 pm, "mpepp...@peppler.org [Team Sybase]"

<michael.pepp...@gmail.com> wrote:
> On Jul 23, 11:48 am, weird0 <amiredi...@gmail.com> wrote:
>
> > How do i check the rowcount of the last ran select query in my
> > procedure...?
>
> > Oracle has something like SQL%ROWCOUNT or SQL%ROWNUM to implement it.
>
> > How do I implement that in Sybase ?
>
> select @@rowcount
>
> Michael

Thanks man...