Uniformkey

Question

Post reply

Uniformkey

Roger Abram

Hall of Fame

Points: 3683
More actions
September 22, 2008 at 3:07 pm

#382775

I've been asked to add a field to a table and the type should be "uniformkey"
Not sure what that is!
Does anyone know?
Thank you.
Roger

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

There's no such data type in SQL Server.

Can you get some clarification from the person who requested this as to what they mean?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Jeff Moden SSC Guru Points: 1004339 More actions · Answer 2

Roger Abram (9/22/2008)
I've been asked to add a field to a table and the type should be "uniformkey"
Not sure what that is!
Does anyone know?
Thank you.
Roger

They probably mean "UniqueIdentifier".

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Roger Abram Hall of Fame Points: 3683 More actions · Answer 3

That's exactly what it turned out to be.

Thank you.

Roger

Jeff Moden SSC Guru Points: 1004339 More actions · Answer 4

Thanks for the feedback, Roger. Heh... you're going to learn to love UniqueIdentifiers about as much as you'll learn to hate them. I love them because they're guaranteed to be unique, but every time I have to read one of the buggers and then maybe type it for troubleshooting purposes, both me and my old eyes really hate them. 😛

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)