Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Unique Identifier like MS SQL server rowguid

Status
Not open for further replies.
beanNut

beanNut

IS-IT--Management
Joined
Jun 2, 2004
Messages
28
Location
US
The generate_unique() does pretty good. But I would like to have server create a truly unique key since I would
not want a user to RESET his internal processing date and create problems creating a duplicate key

Is there any solution for this??
 
Sort by date Sort by votes
Bean,

Would an Identity column be of use?

Marc
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

MichaelDe
  • Locked
  • Question Question
SQL Update with File Join
Replies
10
Views
2K
MichaelDe
MichaelDe
gdg1976
  • Locked
  • Question Question
db2 sql extract double rows (different in case sensitive)
Replies
6
Views
747
mikrom
mikrom
Xenofon Grigoriadis
  • Locked
  • Question Question
PL/SQL or SQL PL
Replies
0
Views
347
Xenofon Grigoriadis
Xenofon Grigoriadis
gdg1976
  • Locked
  • Question Question
sqlcode -802
Replies
0
Views
604
gdg1976
gdg1976
hugoscp1
  • Locked
  • Question Question
sql query
Replies
2
Views
371
hugoscp1
hugoscp1

Part and Inventory Search

Sponsor

Back
Top