What is GUID in SQL 2005?

Globally Unique Identifier, a unique 128-bit number that is produced by the Windows OS or by some Windows applications to identify a particular component, application, file,database entry, and/or user. For instance, a Web site may generate a GUID and assign it to a user's browser to record and track the session. A GUID is also used in a Windows registry to identify COM DLLs. Knowing where to look in the registry and having the correct GUID yields a lot information about a COM object (i.e., information in the type library, its physical location, etc.). Windows also identifies user accounts by a username (computer/domain and username) and assigns it a GUID. Some database administrators even will use GUIDs as primary key values in databases.

GUIDs can be created in a number of ways, but usually they are a combination of a few unique settings based on specific point in time (e.g., an IP Address, network MAC Address, clock date/time, etc.).

Create GUID (guidgen.exe)

Generates a GUID in a specified format.

When you start guidgen.exe, or when you click the New GUID button in the Create GUID dialog box, guidgen.exe generates a GUID.

To run guidgen.exe from the IDE

On the Tools menu, click Create GUID. The Create GUID tool appears with a GUID in the Result box.
Select the format you want for the GUID.
Click Copy.

The GUID is copied to the Clipboard so that you can paste it into your source code.
If you want to generate another GUID, click New GUID.

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Dharmendra Gaur17y ago
Accepted answer
Globally Unique Identifier, a unique 128-bit number that is produced by the Windows OS or by some Windows applications to identify a particular component, application, file,database entry, and/or user. For instance, a Web site may generate a GUID and assign it to a user's browser to record and track the session. A GUID is also used in a Windows registry to identify COM DLLs. Knowing where to look in the registry and having the correct GUID yields a lot information about a COM object (i.e., information in the type library, its physical location, etc.). Windows also identifies user accounts by a username (computer/domain and username) and assigns it a GUID. Some database administrators even will use GUIDs as primary key values in databases.
GUIDs can be created in a number of ways, but usually they are a combination of a few unique settings based on specific point in time (e.g., an IP Address, network MAC Address, clock date/time, etc.).
Create GUID (guidgen.exe)

Generates a GUID in a specified format.

When you start guidgen.exe, or when you click the New GUID button in the Create GUID dialog box, guidgen.exe generates a GUID.

To run guidgen.exe from the IDE
1. On the Tools menu, click Create GUID. The Create GUID tool appears with a GUID in the Result box.
2. Select the format you want for the GUID.
3. Click Copy.
  
  The GUID is copied to the Clipboard so that you can paste it into your source code.
4. If you want to generate another GUID, click New GUID.
0
Kirtan Patel17y ago
Hi i replied your same questions answer here

http://www.c-sharpcorner.com/Forums/ShowMessages.aspx?ThreadID=64103
0
roy himanshu17y ago
hi,
thanx for ur response,but i want GUID Query?how to create table and columns.inthis columns its contain COL_ID,it is uniqueidentifier and primarykey.plz tell me

0