How can I generate random reference number easily. Because I have 10-15 tables and in each tables need to generate a reference number except the primary key. What is the best way to generate reference number and no duplication in each tables. Now I am generating
with the combination of DAY-MONTH-YEAR-HOUR-MINUTE-SECOND-MILISECOND. Because I dont want to check each time in the DB.
What are the best ways??
Please help.
Thanks in Advance.
Go to the complete details ...