Post
Ask Question

Gaurav Malviya
How to access the current value and next value from a sequence? Is it possible to access the current value in a session before accessing next value?
By Gaurav Malviya in SQL Server on Jan 14 2014
  • Naitik Jani
    Apr, 2014 10

    SELECT NEXT VALUE FOR [SequenceName] for accessing Next VALUE of Sequence.We can view Current value of Sequence by right clicking on Sequnece name in Programmability-->Sequence-->[SeuquenceName] in SSMS 2012 or later.

    • 0
  • Gaurav Malviya
    Jan, 2014 14

    Sequence name CURRVAL, sequence name NEXTVAL. It is not possible. Only if you access next value in the session, current value can be accessed.

    • 0


Most Popular Job Functions

View All

MOST LIKED QUESTIONS