Joined: 20 Jan 2004
I am going to use the following query for generating the randon number for program A.
SELECT DECIMAL (RAND() * 999999999999 ,12,0)
DECIMAL (RAND() * 999999999999 ,12,0)
If the same query used by program B (In parallel with A). Is there any chance of duplicate random number generated by A and B if they run parallel.
Thanks in advance