What is the difference between scope_identity() and current_identity()?

Posted by Kmandapalli on 1/20/2014 | Category: C# Interview questions | Views: 2824 | Points: 40

Post |

Interview FAQs |

Exclusive Questions |

Interview Home

Answer:

Both of them are similar and they will return the last identity value generated in the table.
The difference is that scope_identity() returns the identity value that is currently in scope.

Asked In: Many Interviews | Alert Moderator

Bookmark It

< Previous : What does the statement System.exit(0) indicate?

Next > : What is the default value of string and integer in ...

Comments or Responses

More Interview Questions by Kmandapalli

What are the new features introduced in .net framework 4.5.1?
What are the advantages you get by using generics?
How do yo define generics in C#?
How will the data gets passed between controller and views?
What are the responsibilities of transport layer?
What is the role played by physical layer?
Which of the following statement is correct with respect to the below ...
Which of the following is true with respect to inheritance mechanism? ...

Latest Interview Questions

What is the default value of string and integer in DotNet?
How to check whether string has been assigned a value or not?
How to check whether record is present or not in a table?
How many ways of converting string date into datetime?
How to convert string date into datetime?
How to access View?
How to create a View in Sql Server?
How to convert "19/01/2014" into 19-Jan-2014?
More ...