Generate unique ID in SQL Server

We can generate unique ID in select statement.

CREATE TABLE TableN
(Val VARCHAR(200))

INSERT INTO TableN
SELECT 'A1' UNION ALL
SELECT 'B1' UNION ALL
SELECT 'C1' UNION ALL
SELECT 'D1' 

SELECT NEWID() AS 'Unique ID',Val FROM TableN

Output will look like as below



That's It
Enjoy Learning.