Oracle to SQL Server

I have this Oracle query: SELECT FOI_CLIENT_ID_SEQ.NEXTVAL FROM DUAL that get the next client ID, and I would like to do a similar query in SQL Server 2000, considering that the table is empty at first.
soliveiraAsked:
Who is Participating?
 
mayno224Connect With a Mentor Commented:
Sequences do not exist for SQL Server.  It uses Identity instead.  Checkout this discussion...

http://forum.java.sun.com/thread.jspa?messageID=10296634&tstart=0

Hope this helps.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.