How can we use of GUID Data type.

lakshman

Hi Experts ,

I dont Know how to use and which type of data it accepts.
Please Suggest me.


Thanks & Regards

lakshman

satraja2004

Use this data type to give a unique identifying number to any database object. The Globally Unique Identifier (GUID) data type is a 16 byte binary data type. This data type is used for the global identification of objects, programs, records and so on.
The most important property of a GUID is that each value is globally unique. The value is generated by an algorithm, developed by Microsoft, which assures this uniqueness.
The GUID is a 16 byte binary data type and can be logically grouped into the following subgroups: 4byte-2byte-2byte-2byte-6byte. The standard textual representation is {12345678-1234-1234-1234-1234567890AB}.

This i got from a book.
still u can get lot if information from others.
Hope so it helps u a little.

lakshman

hi satraja2004 ,

Thank You For this valuable information ,can u provide any example for how to define the variable.



Thanks & Regards
LAKSHMAN

satraja2004

Hi,

sorry for late reply.

first u need to create a field with data type GUID.

then there is one function called CREATEGUID. \:D/

by using this function, this will automatically create GUID's for u. \:D/