View Single Post
 
Old August 9th, 2005, 04:33 PM
Imar's Avatar
Imar Imar is offline
Wrox Author
Points: 70,322, Level: 100
Points: 70,322, Level: 100 Points: 70,322, Level: 100 Points: 70,322, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,089
Thanks: 80
Thanked 1,576 Times in 1,552 Posts
Default

Yeah, I understand that. However, creating an entire DataReader with a full SELECT statement is just overkill. The output param with a COUNT gives you the same information and will run faster.

Cheers,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.