Google News
logo
SQL Server - Quiz(MCQ)
Which of the following global has return type 'numeric'?
A)
@@ERROR
B)
@@IDENTITY
C)
@@CPU_BUSY
D)
@@MAX_CONNECTIONS

Correct Answer :   @@IDENTITY


Explanation : @@identity retains the last value inserted into an IDENTITY column, even if the statement that inserted it fails to commit.

Advertisement