python ruby-programming-language Smalltalk Vue.js Knockoutjs TypeScript JavaScript, OOPs JavaScript Angular 8,7,6,5,4 and 2 Interview Questions and Answers Angular 8,7,6,5,4 and 2 Interview Questions and Answers Angular 4 Angular 2 AngularJs 1.x NodeJs Perl Programming R Programming RequireJs Rust Programming Backbonejs closure programming language go-programming-language kotlin-programming-language
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

Hi there! Welcome to my blog. My name is Anil Singh. I'm a author of this blog. For more detail about me, kindly refer to this link..
My Blogs - http://code-sample.com and http://code-sample.xyz
My Books - Interview Questions and Answers Books- Get Your Book in 15+ Digital Stores Worldwide..

You Might Also Like
www.code-sample.com/. Powered by Blogger.
ASK Questions