GUID is not an identity field

[Jason L James]

Hi all,

I am using merge replication between my SQL 2K and CE
databases.

I am using GUID types as the PK of my data table. However,
I would like to return the value of the PK once the record has
been written. I am using newID() in the SQL CE DB so the DB
is adding the GUID value. Therefore I can not use

SELECT @@IDENTITY

does anyonce have any ideas how I can return the PK
of the most recently added record?

Thanks,

Jason.

 

[Chris Tacke, eMVP]

Sure. Add a datetime field and select the most recent.

-Chris

 

[Alex Feinman [MVP]]

Or add an INT IDENTITY field - less space than datetime