Generate New (uniqueidentifier) in SQL Server

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

       -- Example 1
       SELECT NEWID()

       -- Example 2       
       DECLARE @EmployeeID uniqueidentifier
       SET @EmployeeID = NEWID()

       -- Example 3
       INSERT INTO Employees(EmployeeID, Name)
       VALUES (NEWID(), 'msm2020')

       -- Example 1
       SELECT NEWID()

       -- Example 2       
       DECLARE @EmployeeID uniqueidentifier
       SET @EmployeeID = NEWID()

       -- Example 3
       INSERT INTO Employees(EmployeeID, Name)
       VALUES (NEWID(), 'msm2020')

1. <code>
2. -- Example 1
3. SELECT NEWID()
5. -- Example 2
6. DECLARE @EmployeeID uniqueidentifier
7. SET @EmployeeID = NEWID()
9. -- Example 3
10. INSERT INTO Employees(EmployeeID, Name)
11. VALUES (NEWID(), 'msm2020')
13. </code>

<code>
       -- Example 1
       SELECT NEWID()

       -- Example 2       
       DECLARE @EmployeeID uniqueidentifier
       SET @EmployeeID = NEWID()

       -- Example 3
       INSERT INTO Employees(EmployeeID, Name)
       VALUES (NEWID(), 'msm2020')

</code>