Marc,

To add to Sergey's answer, @@idenity returns the value of the column defined as IDENTITY in the table.

CREATE TABLE [xyz] (
	[xyzno] [int] IDENTITY (1, 1) NOT NULL ,

>Why the following returns NULL value?
>
>INSERT INTO (...) VALUES (...)
>SELECT @@IDENTITY
>
>P.S.: The UniqueIdentifier is correctly generated.