|
Posted by imani_technology_spam@yahoo.com on 09/16/06 00:03
The table in the database has a field called LabID. That field is an
integer and consists of the year plus a counter. For example, the
first record of 2006 would be "20060001," the second record of 2006
would be "20060002" and so on. I'm trying to create an Insert trigger
that can generate the ID value when a new record is inserted, but I'm
not quite sure how to implement that trigger. Can anyone help?
Navigation:
[Reply to this message]
|