SQL Server uniqueidentifier GUID auto generated

--CREATE TABLE USING AUTOINCREMENT UNIQUEIDENTIFIER.

CREATE TABLE [DBO].[GUID_DEMO](

                [ID] [BIGINT] IDENTITY(1,1) NOT NULL,

                [GUIDS] [UNIQUEIDENTIFIER] NOT NULL,

                [EMPID] [NVARCHAR](20) NOT NULL,

                [EMPNAME] [NVARCHAR](255) NOT NULL

) ON [PRIMARY]

GO

   ALTER TABLE [DBO].[GUID_DEMO] ADD  CONSTRAINT [DF__GUID_DEMO__GUIDS__058EC7FB]  DEFAULT (NEWID()) FOR [GUIDS]

GO

--INSERT ROWS VALUES IN THE TABLE.

INSERT INTO [DBO].[GUID_DEMO] ([EMPID], [EMPNAME])VALUES('VIA01','ANIL SINGH')

INSERT INTO [DBO].[GUID_DEMO] ([EMPID], [EMPNAME])VALUES('VIA02','SUNIL SINGH')

INSERT INTO [DBO].[GUID_DEMO] ([EMPID], [EMPNAME])VALUES('VIA03','SUSHIAL SINGH')

INSERT INTO [DBO].[GUID_DEMO] ([EMPID], [EMPNAME])VALUES('VIA04','ARADHYA SINGH')

INSERT INTO [DBO].[GUID_DEMO] ([EMPID], [EMPNAME])VALUES('VIA05','REENA SINGH')

--SELECT INSERTED ROWS.

SELECT * FROM [DBO].[GUID_DEMO]

--DROP TABLE

DROP TABLE [DBO].[GUID_DEMO]