searching for microsoft sql server equivalent of postgresql form

Question

SELECT nextval('AWARD_ID')

I am getting nextval as not built in function name in MS SQL Server. Kindly give any alternative if there is any.

wilx · Accepted Answer · 2015-11-23 06:30:19Z

2

answered Nov 23, 2015 at 6:30

wilx

18.3k7 gold badges66 silver badges123 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Harsh · Accepted Answer · 2015-11-23 06:31:20Z

-1

Do you mean something like IDENT_CURRENT():

select IDENT_CURRENT('FOO') + IDENT_INCR('FOO')

answered Nov 23, 2015 at 6:31

Harsh

1,3178 silver badges14 bronze badges

This calculates the next value but wouldn't advance the sequence (unlike Postgres' nextval())