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?

Post

By Gaurav Malviya in SQL Server on Jan 14 2014

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
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