Solved

Oracle to SQL Server

Posted on 2008-06-16
1
233 Views
Last Modified: 2013-12-19
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.
0
Comment
Question by:soliveira
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 2

Accepted Solution

by:
mayno224 earned 500 total points
ID: 21798586
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

Featured Post

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…

615 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question