RowCount and Stored Procedures
Recently I thought the SQL Server RowCount functions were lying to me - telling me there was only one row being returned by stored procedures that performed Select statements only - Select statements that I knew returned more than a single row.
I discovered the culprit after some digging: the Return statement at the end of the procedure was, in fact, returning 0 - which is technically one row.
:{> Andy
Technorati Tags: