SQL Server uniqueidentifier GUID auto generated

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 [DBO].[GUID_DEMO]



ANIL SINGH

Hey! I'm Anil Singh. I author this blog. I'm Active Blogger, Programmer. I love learning new technologies, programming, blogging and participating the forum discussions more...
My Blogs - http://www.code-sample.com and http://www.code-sample.xyz
My Books - Google Amazon and Flipkart Book Store!

You Might Also Like
Post a Comment
www.code-sample.com/. Powered by Blogger.