|
Posted by Alexander Kuznetsov on 02/14/06 18:01
I successfully used a transactional message queue for a similar
scenario.
Besides, try this:
create table #pins(id int identity, PIN decimal(10));
insert into #pins(PIN)values(1000000000);
insert into #pins(PIN)values(1000000001);
insert into #pins(PIN)values(1000000002);
go
create table #point_to_pins(id int identity)
go
---to get a PIN
insert into #point_to_pins default values
select @@identity
use @@identity to get the PIN, you will not get any collisions ever
Navigation:
[Reply to this message]
|