guid

How to create a GUID in Excel?

by

As of modern version of Excel, there’s the syntax with commas, not semicolons. I’m posting this answer for convenience of others so they don’t have to replace the strings- We’re all lazy… hrmp… human, right? =CONCATENATE(DEC2HEX(RANDBETWEEN(0,4294967295),8),”-“,DEC2HEX(RANDBETWEEN(0,65535),4),”-“,DEC2HEX(RANDBETWEEN(0,65535),4),”-“,DEC2HEX(RANDBETWEEN(0,65535),4),”-“,DEC2HEX(RANDBETWEEN(0,4294967295),8),DEC2HEX(RANDBETWEEN(0,65535),4)) Or, if you like me dislike when a guid screams and shouts and you, we can go lower-cased like … Read more

What is {{$guid}} used for in Postman?

by

GUID is the acronym for “Globally Unique Identifier”. A GUID is mainly used to produce hexadecimal digits with groups separated by hyphens for uniqueness purposes, for example: b3d27f9b-d21d-327c-164e-7fb6776f87b0 In postman you can use this to generate and send a random GUID to your api as required: { “id”: “{{$guid}}”, } On Send would produce(with the … Read more

C# guid and SQL uniqueidentifier

by

Here’s a code snippet showing how to insert a GUID using a parameterised query: using(SqlConnection conn = new SqlConnection(connectionString)) { conn.Open(); using(SqlTransaction trans = conn.BeginTransaction()) using (SqlCommand cmd = conn.CreateCommand()) { cmd.Transaction = trans; cmd.CommandText = @”INSERT INTO [MYTABLE] ([GuidValue]) VALUE @guidValue;”; cmd.Parameters.AddWithValue(“@guidValue”, Guid.NewGuid()); cmd.ExecuteNonQuery(); trans.Commit(); } }

What are the project GUIDs in a Visual Studio solution file used for?

by

Project persistence block in a solution file has the following format: Project(“{project type GUID}”) = “<Project name>”, “<project file location>”, “{<Unique project GUID>}” EndProject So it’s expected that first GUID is non-unique, it uniquely identifies Visual Studio package that handles this type of projects. The GUID you posted is interesting – it looks like mangled … Read more

A TypeScript GUID class? [closed]

by

Updated Answer This is now something you can do natively in JavaScript/TypeScript with crypto.randomUUID(). Here’s an example generating 20 UUIDs. for (let i = 0; i < 20; i++) { let id = crypto.randomUUID(); console.log(id); } Original Answer There is an implementation in my TypeScript utilities based on JavaScript GUID generators. Here is the code: … Read more

How to convert a GUID to a string in C#?

by

According to MSDN the method Guid.ToString(string format) returns a string representation of the value of this Guid instance, according to the provided format specifier. Examples: guidVal.ToString() or guidVal.ToString(“D”) returns 32 hex digits separated by hyphens: 00000000-0000-0000-0000-000000000000 guidVal.ToString(“N”) returns 32 hex digits:00000000000000000000000000000000 guidVal.ToString(“B”) returns 32 hex digits separated by hyphens, enclosed in braces:{00000000-0000-0000-0000-000000000000} guidVal.ToString(“P”) returns 32 … Read more

How many characters are there in a GUID?

by

From MSDN: A GUID is a 128-bit value consisting of one group of 8 hexadecimal digits, followed by three groups of 4 hexadecimal digits each, followed by one group of 12 hexadecimal digits. The following example GUID shows the groupings of hexadecimal digits in a GUID: 6B29FC40-CA47-1067-B31D-00DD010662DA From Wikipedia: Often braces are added to enclose … Read more

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)