Multiple choice technology databases

In Sybase what returns the number of row affected by the preceding query

  1. @@trancount

  2. @@rowcount

  3. @@sqlstatus

  4. @@rescount

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

@@rowcount returns the number of rows affected by the last statement in Sybase. This is a system variable used to check the impact of INSERT, UPDATE, or DELETE operations. @@trancount tracks transactions, @@sqlstatus is for cursor status, and @@rescount does not exist.