Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-01-16 : 09:53:45
|
| Lee writes "Hello,I’m trying to create a unique ID for a database management system. I'm currently using the following data type to generate the ID uniqueness.data type = uniqueidentifierdefault value = (newid())The main problem with this function is that the outputted results are very long and complex ({FA78C269-F7AA-4D2B-B52F-14D5F37157BB}). To this end I would very much appreciate if you could advise me with any way I can shorten this unique ID.Many Thanks,Lee Scott" |
|
|
smccreadie
Aged Yak Warrior
505 Posts |
Posted - 2002-01-16 : 10:25:01
|
| If you're working within a single table, you can use an IDENTITY field to do this. Otherwise I think your stuck with GUIDs or inventing your own schema to do this. |
 |
|
|
|
|
|
SQL Server - Unique ID