Dragan,

Very interesting. I played with this a little on the database I use (Sybase ASA) and the GUID is stored in a binary(16) data type. @@identity returns 0 instead of null. Doesn't help much.


>>Michael
>>
>>Select @@identity
>
>Doesn't work, returns null if you have an uniqueidentifier column but don't have an identity column. Try this:
>

create table dum (bz uniqueidentifier, c varchar(10))
>insert into dum (c) values ('zz')
>select @@identity

>I'm getting a null returned (MSDE 2000).