Auto generate "haux" number

[Thuky]

Hello,

Happy Sunday!!!

Can anyone please help me how to generate haux number (I'm not sure how to spell haux or haeux)? I don't want to auto generate ID for my table.

Thanks a bunch in advance!!!

 

[jbenson001]

What is a "Haux" number? Do you mean GUID? Use NewID()

 

[SQLDenis]

Maybe you mean faux numbers like Gazillion?

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[Gooser]

What sort of hoax are you constructing here?

v/r

Gooser

Why do today
that which may not need to be done tomorrow --me

 

[mhoyt]

I'm thinking you mean "hash", in which case you want to look at CHECKSUM

From BOL
"Returns the checksum value computed over a row of a table, or over a list of expressions. CHECKSUM is intended for use in building hash indices."

Hope this helps....

 

[Thuky]

Thanks all for trying to help me look for the right word. I meant hoax number as Gooser figured it out. Thanks, Gooser.

I am trying to construct a form of ID that no one can gess what my next ID in the table. The ID can be a few letters mixed with a few numbers.

Please help...

Thank You.

 

[SQLDenis]

Use NEWID() with a GUID

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/