Select from following answers:- SCOPE_IDENTITY
- ROWCOUNT
- @@ROWCOUNT
- @@IDENTITY
- All Above
SCOPE_IDENTITY is the best answer. Although you could use @@IDENTITY, you need to be careful here, since it's across scopes. You could get a value from a trigger, instead of your current statement.
Show Correct Answer
Asked In: Many Interviews |
Alert Moderator