How to generate GUID in MS SQL?

Question

SQL Server

How much understood, it is possible with the help of data type uniqueidentifier
But how to make, as an auto increment?
I didn’t quite understand.. I set it up, entered the test string, but the id is not generated..

Answer 1

CREATE TABLE TestGUID	(
  ID UNIQUEIDENTIFIER NOT NULL PRIMARY KEY DEFAULT NEWID(),
  Name VARCHAR (50) NOT NULL )

Documentation .