Execute the following Microsoft SQL Server T-SQL script in SSMS Query Editor to populate a table with uniqueidentifier:

USE AdventureWorks;

GO

USE tempdb;

GO

IF OBJECT_ID('dbo.Email','U') IS NOT NULL

  DROP TABLE dbo.Email;

GO

CREATE TABLE dbo.Email (

  EmailID   INT    IDENTITY,

  UniqueID  UNIQUEIDENTIFIER,

  FirstName CHAR(15),

  LastName  CHAR(20),

  Email     VARCHAR(75));

GO

INSERT INTO dbo.Email

           (FirstName,

            LastName,

            Email,

            UniqueID)

VALUES     ('Bob','Smith','bobsmith777@aol.com',NEWID());

INSERT INTO dbo.Email

           (FirstName,

            LastName,

            Email,

            UniqueID)

VALUES     ('Kimberly','White','kimberlywhite777@yahoo.com',NEWID());

INSERT INTO dbo.Email

           (FirstName,

            LastName,

            Email,

            UniqueID)

VALUES     ('Ron','Rogers','ronrogers777@hotmail.com',NEWID());

INSERT INTO dbo.Email

           (FirstName,

            LastName,

            Email,

            UniqueID)

VALUES     ('Elvis','Presley','elvispresley777@earthlink.net',NEWID());

INSERT INTO dbo.Email

DEFAULT VALUES;

GO

SELECT   *

FROM     dbo.Email

ORDER BY Email;

GO

IF OBJECT_ID('dbo.Email','U') IS NOT NULL

  DROP TABLE dbo.Email;

GO

Related article:

uniqueidentifier (Transact-SQL)