[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[Omaha.pm] Re: Getting @@ROWCOUNT


On Nov 17, 2004, at 5:03 PM, Michael D. Maynard wrote:
Do you know how to get @@ROWCOUNT from MSSQL for a query with PERL? DBI rows() is not supported. :-(
Hmmm... here's an example of @@identity. I assume @@rowcount would work the same way? 

      my $strsql = "insert into blah....";
      $strsql .= ' select @@identity';
      # print "\n\n$strsql\n\n";
      my $sth = $dbh->prepare($strsql);
      $sth->execute;
      my @row = $sth->fetchrow_array;
      $sth->finish;
      print "Just inserted new ID '$row[0]'\n";

HTH,

j