Skip to Content.
Sympa Menu

freetds - Re: [freetds] rowcount not available? [NC]

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Mittel, Alexander" <Alexander.Mittel AT siemens.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] rowcount not available? [NC]
  • Date: Fri, 14 Aug 2009 07:41:24 +0200


Hi,
this is a FreeTDS-mailing list, not a SQLServer-forum :-)

But: "set rowcount nn" is something completly different then "@@ROWCOUNT".
"set rowcount 10" limits the number of returned rows when doing a SELECT. If
a table has 20 rows then only 10 rows will be returned.
"@@ROWCOUNT" is set by SQLServer and contains the number of affected rows,
i.e. with UPDATE
Maybe look at MS doc to see
Mfg Alexander


-----Ursprüngliche Nachricht-----
Von: freetds-bounces AT lists.ibiblio.org
[mailto:freetds-bounces AT lists.ibiblio.org] Im Auftrag von Cedric ROUVRAIS
Gesendet: Donnerstag, 13. August 2009 21:33
An: FreeTDS Development Group
Betreff: [freetds] rowcount not available? [NC]



Hi,

Me again, anybody have any clues? When I execute select @@ROWCOUNT I get
the correct count that is to say. Why would the rowcount not be available ?

a++ Cedric
__________________

Hi guys,

I have come across an interesting behaviour with SQL Server 2008, when you
use the instruction: "set rowcount nn" such as "set rowcount 10" then
DBCOUNT(dbproc) returns -1.

Anyone have any ideas???

Thanks,

Cedric




Archive powered by MHonArc 2.6.24.

Top of Page