View Single Post
  #10 (permalink)  
Old June 14th, 2004, 11:20 PM
Justin Cave Justin Cave is offline
Authorized User
 
Join Date: Apr 2004
Location: Boise, ID, USA.
Posts: 70
Thanks: 0
Thanked 0 Times in 0 Posts
Default

You need to have a sequence and a BEFORE INSERT trigger in Oracle to replicate the "auto increment" functionality in SQL Server.

I have an example of setting this up in another forum http://www.ddbcinc.com/askddbc/topic.asp?TOPIC_ID=239 (free registration required).

Justin
Distributed Database Consulting, Inc.
http://www.ddbcinc.com/askDDBC