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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Setting Primary Key from Trigger(?)

Status
Not open for further replies.
orangey

orangey

Programmer
Dec 20, 2001
4
US
Hi -

I need to have a primary key set for a user everytime they add a new record to the database.

I need the PK to be 10 digits long and to start with "020102" and go up incrementally from there.

Any suggestions how to do this?

thanks.
 
Status
Not open for further replies.

Similar threads

bharons
  • Locked
  • Question
Pick up value from combobox
Replies
0
Views
402
bharons
bharons
grnzbra
  • Locked
  • Question
Conditional Foreign Key Constraint
Replies
1
Views
209
Chris Miller
Chris Miller
grnzbra
  • Locked
  • Question
GOING FROM DD/MM/YYYY TO MM/DD/YYYY 1
Replies
4
Views
516
JeffModen
JeffModen
Auguy
  • Locked
  • Question
Move From SQL 2014 Express To Newer Version
Replies
2
Views
153
Auguy
Auguy
eboughey1008
  • Locked
  • Question
Import columns from one table into another table with dissimilar field layout
Replies
7
Views
216
Chris Miller
Chris Miller

Part and Inventory Search

Sponsor

Back
Top