Solved

Oracle to SQL Server

Posted on 2008-06-16
1
226 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
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

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

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

Suggested Solutions

Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
Via a live example, show how to take different types of Oracle backups using RMAN.

803 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