General information
Title:
Primary Key generation
Hello,
I want to use MS sql database for my vfp program. In vfp I use a table with fields to generate primary keys for various tables. I lock the field and increment it and then format it according to my requirement like "Vno-00001".
How can I do this in sql table from vfp? Should I use
1) a stored procedure to generate the PK with Transaction Islolation
2) An Insert statement with any explicit lock hints.
I know that the best option is to use Identity column as searched on web. But I need to generate a PK or an Alternate key to identify my record with some serial numbers that based on month or year.
TIA
Naeem
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only