How to create unique identity columns?

[Thorsten Tarrach]

Hallo,
With IDENTITY(1,1) I can create an AutoIncrement Column.
I however need a column with a uniqueidentifier that is created whenever a
new datarow is created.
This is possible with access, but how can I create such a column via SQL?
Thorsten

 

[Miha Markic [MVP C#]]

Hi Thorsten,

Are you talking about columns on server?
Sql server has IDENTITY keyword.

 

[Thorsten Tarrach]

No, I'm using Access.

Hi Thorsten,

Are you talking about columns on server?
Sql server has IDENTITY keyword.

True, but identity works only with int values. There is no way to create
GUIDs.

 

[Miha Markic [MVP C#]]

Hi Thorsten,

Yes, seems that it is missing or at least well hidden.
As a workaround you might create GUIDs in code or use ADOX to create such a
column.