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.

Answer 1

Do you mean something like IDENT_CURRENT():

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

Answer 2

It seems you are looking for SELECT NEXT VALUE FOR award_id.