Home Forums Article Discussions Article Discussions by Author Discuss content posted by Amit mishra Rowcount RE: Rowcount
jadsmith
Hall of Fame
Points: 3007
More actions
January 28, 2010 at 9:39 pm
#1110446
First result depends on what has been run previously in the query window. If nothing has been run, then get a 1, second result is 1.
If a SET option e.g. SET NOCOUNT ON/OFF has been done first, then the first result is a 0