Need smartway to find out the number of rows and datasize of a select query results?

• sqlprabha

  Newbie

  Points: 3

  More actions

  September 16, 2009 at 2:58 pm

  #209943

  Hi All,

  Could you please suggest me is there is any smartway to find out the number of rows and datasize of a select query result?

  Thanks,

  SQLPrabha

• Ron McCullough

  SSC Guru

  Points: 63877

  More actions

  September 16, 2009 at 3:05 pm

  #1054721

  Look in Books On Line for the function @@Rowcount

  ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/97a47998-81d9-4331-a244-9eb8b6fe4a56.htm

  Returns the number of rows affected by the last statement

  If everything seems to be going well, you have obviously overlooked something.

  Ron
  
  Please help us, help you -before posting a question please read[/url]
  Before posting a performance problem please read[/url]