Difference Between SCOPE_IDENTITY and atatROWCOUNT in sql server
SCOPE_IDENTITY
Returns the last identity value inserted into an identity column in the same scope. A scope is a module: a stored procedure, trigger, function, or batch. Therefore, two statements are in the same scope if they are in the same stored procedure, function, or batch.
ROWCOUNT"
Returns the number of rows affected by the last statement.
Showing posts with label Difference Between SCOPE_IDENTITY and ROWCOUNT in sql server. Show all posts
Showing posts with label Difference Between SCOPE_IDENTITY and ROWCOUNT in sql server. Show all posts
18 September 2010
Subscribe to:
Comments (Atom)