Ezeji

-- If you want to generate a new Guid (uniqueidentifier) in SQL server the you can simply use the NEWID() function.

SELECT NEWID()
GO
-- This will return a new random uniqueidentifier e.g.
E75B92A3-3299-4407-A913-C5CA196B3CAB
To select this Guid in in a variable

--assign uniqueidentifier in a variable
DECLARE @EmployeeID uniqueidentifier