how to find the number of rows in a result of a query

• deenadayalan

  Say Hey Kid

  Points: 670

  More actions

  April 14, 2006 at 12:34 am

  #112757

  hi

  I would like to know how to find the no. of rows in a resultset of a query

  (Ex. SQLNumResultCols gives the no. of colums).

  deena

• Sergiy

  SSC Guru

  Points: 110208

  More actions

  April 14, 2006 at 5:37 am

  #632576

  SELECT @@Rowcount

  _____________
  Code for TallyGenerator

• deenadayalan

  Say Hey Kid

  Points: 670

  More actions

  April 14, 2006 at 6:36 am

  #632589

  Thanx

  it works