Unique Number like GUID

[David Pope]

I need to create a unique number like a GUID but all numbers.

Does anyone know of algorithm to do this?

Thanks,

David

[L.M]

Hello,

I'm using a call like this one:

GuidKey = System.Guid.New Guid().ToString ("N");

Yo ucan select the 'format' you want.
L.M

"David Pope" <dp***@nospam.s atx.rr.com> wrote in message
news:O8******** ******@TK2MSFTN GP09.phx.gbl...

I need to create a unique number like a GUID but all numbers.

Does anyone know of algorithm to do this?

Thanks,

David

[JohnnyAppleseed]

Unique in what context? Unique at the transaction level, table level or
globally (outside the server)?

There are several options, but if this data is to inserted into a table,
then you will want to consider the storage requirements of the values. A
GUID (ex: 6F9619FF-8B86-D011-B42D-00C04FC964FF) is 32 bytes in alpha-numeric
format and would still require a (8 byte) Big Int if converted to numeric.
If you just need a unique numeric value inserted into a table column, then
an auto incremented integer would be the logical choice.
"David Pope" <dp***@nospam.s atx.rr.com> wrote in message
news:O8******** ******@TK2MSFTN GP09.phx.gbl...

I need to create a unique number like a GUID but all numbers.

Does anyone know of algorithm to do this?

Thanks,

David

[Rakesh Rajan]

Hi David,

I don't know your context, so I don't know whether this method is the best.

So, in addition to the others, let me also suggest using the
RNGCryptoServic eProvider class (in the System.Security .Cryptography
namespace), which derives from the RandomNumberGen erator class.
Eg: (in the context of creating a salt)

byte[] saltInBytes = new byte[8];
RNGCryptoServic eProvider saltGenerator = new RNGCryptoServic eProvider();
saltGenerator.G etBytes(saltInB ytes);
string saltAsString = Convert.ToBase6 4String(saltInB ytes);

HTH,
Rakesh Rajan

"David Pope" wrote:

I need to create a unique number like a GUID but all numbers.

Does anyone know of algorithm to do this?

Thanks,

David

[Ollie Riches]

if it is not that frequent how aboout using the current date & time

e.g.

DateTime.Now.Ti cks

HTH

Ollie Riches

"David Pope" <dp***@nospam.s atx.rr.com> wrote in message
news:O8******** ******@TK2MSFTN GP09.phx.gbl...

I need to create a unique number like a GUID but all numbers.

Does anyone know of algorithm to do this?

Thanks,

David

[Joerg Bonsack]

I agree with you.
this is a good way.

I use following:
now.ticks + random number.
Maybe you try to calculate with the MAC Adress.

Joerg

"Ollie Riches" <ol**********@h otmail.com> schrieb im Newsbeitrag
news:OL******** *****@TK2MSFTNG P15.phx.gbl...

if it is not that frequent how aboout using the current date & time

e.g.

DateTime.Now.Ti cks

HTH

Ollie Riches

"David Pope" <dp***@nospam.s atx.rr.com> wrote in message
news:O8******** ******@TK2MSFTN GP09.phx.gbl...

I need to create a unique number like a GUID but all numbers.

Does anyone know of algorithm to do this?

Thanks,

David