943,697 Members | Top Members by Rank

Ad:
  • MS SQL Discussion Thread
  • Unsolved
  • Views: 910
  • MS SQL RSS
Nov 5th, 2008
0

Autogenerated Primary Key.. Please Help !!

Expand Post »
When some datas are inserted in to a DB table from a jsp page, how do i get the primary key in my table autogenerated?? finiding out the highest value for the primary key in the table? Pls help me wid the coding in JAVA or HTML.. I use SQL*PLus.
Similar Threads
Reputation Points: 10
Solved Threads: 0
Newbie Poster
lakshma.sugunan is offline Offline
2 posts
since Nov 2008
Nov 5th, 2008
0

Re: Autogenerated Primary Key.. Please Help !!

sql plus is for oracle not for sql server

how are you inserting the record?
i think you are meaning autoincrementing

here is how to do it in oracle
http://www.lifeaftercoffee.com/2006/...mns-in-oracle/
Reputation Points: 133
Solved Threads: 141
Veteran Poster
dickersonka is offline Offline
1,162 posts
since Aug 2008

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in MS SQL Forum Timeline: Logging Stored Procedure from Trigger
Next Thread in MS SQL Forum Timeline: Insert_Update Stored Procedure and returning Identity





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC