CREATE TRIGGER dbo.InsertTriggerOnGUIDYourtable
ON dbo.YourTable
FOR INSERT
AS
BEGIN
     SET NOCOUNT ON
	
     SELECT GUIDCol AS '@@GUID'
     FROM inserted
END

CREATE TRIGGER dbo.InsertTriggerOnGUIDTable2
ON dbo.GUIDTable2
FOR INSERT
AS
BEGIN
	SET NOCOUNT ON
	
	SELECT GUIDCol AS '@@GUID'
	FROM inserted
END
GO

This trigger returns a resultset that includes last inserted record's guid info (uniqueidentifier)

If your column is uniqueidentifier and its default value is newid() , you can't get last record id (guid) with @@identity .

So, I write a trigger on my table to get last record guid info ;)

SQL Inserted Trigger

sql

SQL