What is the return type of @@Identity function?

 Posted by vishalneeraj-24503 on 11/5/2014 | Category: Sql Server Interview questions | Views: 1767 | Points: 40

@@Identity function always returns Numeric Values.
For Example:-
Insert into tbl(col1,col2) values('value1','value2');

Select @@Identity;

Then it will return the last inserted identity column values which is by-default integer.

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response