What is the scope of @@rowcount ?MSDN doesn't mention its scope.
Returns the number of rows affected by the last statement.
Ok.
In my SP — I'm inserting into a table , which has a insert trigger which does another insertion when a new value is inserted to the table.
Question:
To which scope the @@rowcount will refer ? (trigger or SP) ?