What is GUID in SQL 2005?

Question

Hi What is GUID in SQL 2005?how to create GUID?How to insert the values into table when GUID Column is present in that table?plz tell me. Himanshu

Dharmendra Gaur · Answer

G lobally U nique Id entifier a unique 128-bit number that is produced by the Windows OS or by some Windows applications to identify a particular component application filedatabase 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 .

Kirtan Patel · Answer

Hi i replied your same questions answer here http://www.c-sharpcorner.com/Forums/ShowMessages.aspx?ThreadID=64103

roy himanshu · Answer

hi thanx for ur responsebut i want GUID Query?how to create table and columns.inthis columns its contain COL_IDit is uniqueidentifier and primarykey.plz tell me