Tuesday, 18 October 2016

3 Top Difference between Sequence and Identity

Identity and Sequence both are used to generate auto-incrementing numbers. following are the differences:-

  • Sequence is independent from table and Identity is a table dependent
  • In Sequence New value can be obtain before an INSERT statement but Identity values generated when a row inserted into table
  • In Sequence New values can be generate in an UPDATE statement but in Identity new value can not be generate in an UPDATE statement
  • In Sequence, For performance point of view, you can set cache size option and also you can define min and max values, can allow cycling but You cannot define minimum and maximum values,allow cycling, and caching options or not in Identity column

You can find more about Sequence click here

No comments:

Post a Comment

Note: only a member of this blog may post a comment.