Select from following answers:- SCOPE_IDENTITY()
- @@IDENTITY
- IDENT_CURRENT('TableName')
- MAX(id)
- All Above
SCOPE_IDENTITY(), @@IDENTITY, IDENT_CURRENT('TableName') are used for getting auto incremented value from recent INSERT statement in SQL Server
Show Correct Answer
Asked In: Many Interviews |
Alert Moderator