How to generate a Guid in SQL Server?

Question

I need to create an Id as Guid in SQL(no identity) How I can do this? I defined the Id as uniqueidentifier but what is save in Db is 00000000-0000-0000-0000-000000000000

Answer 1

Use NEWID() to generate a Guid in SQL Server like this:

SELECT NEWID()

Answer 2

Create a variable of uniqueidentifier data type. Type the below code in SSMS and execute.

 DECLARE @guid uniqueidentifier = NEWID();
 SELECT @guid as 'GUID';

Here we created a variable named guid of data type uniqueidentifier.

Answer 3

A aspnet role created manually

DECLARE @ID UNIQUEIDENTIFIER
SET @ID = NEWID()

DECLARE @STAMP UNIQUEIDENTIFIER
SET @STAMP = NEWID()

INSERT INTO [dbo].[AspNetRoles]
           ([Id]
           ,[Name]
           ,[NormalizedName]
           ,[ConcurrencyStamp])
     VALUES
           (@ID
           ,'Admin'
           ,'ADMIN'
           ,@STAMP)

Answer 4

To generate a GUID in SQL Server, use the NEWID() function. It produces a globally unique alphanumeric value of 128 bits, ideal for primary keys or unique identifiers in databases.

SELECT NEWID() AS GeneratedGUID;