Anil Singh | Code-sample.com

--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] , [...