Re: Use GUID instead of AutoInc

From: Arthur Hoornweg <antispam.hoornweg@xxxxxxxxxxxxx>
Date: Wed, 23 Apr 2008 18:29:23 +0200

Koen wrote:

I currently use access.. should I declare the field as a Number/Longint?

IIRC, the data type is "uniqueidentifier"

--
Arthur Hoornweg

(In order to reply per e-mail, please just remove the ".net"
from my e-mail address. Leave the rest of the address intact
including the "antispam" part. I had to take this measure to
counteract unsollicited mail.)
.

Follow-Ups:
- Re: Use GUID instead of AutoInc
  - From: Koen

References:
- Use GUID instead of AutoInc
  - From: Koen
- Re: Use GUID instead of AutoInc
  - From: Koen

Prev by Date: Re: issue with AutoInc field and locks
Next by Date: Re: Locking of individual record in table
Previous by thread: Re: Use GUID instead of AutoInc
Next by thread: Re: Use GUID instead of AutoInc
Index(es):
- Date
- Thread

Relevant Pages

Re: Use GUID instead of AutoInc
... IIRC, the data type is "uniqueidentifier" ... Arthur Hoornweg ...
(borland.public.delphi.database.ado)
Re: Data Types
... >> Steve, ... >> Tibor Karaszi, SQL Server MVP ... >>> character varchar data type? ... A uniqueidentifier uses 16 bytes. ...
(microsoft.public.sqlserver.programming)
Re: Data Types
... > moved to SQL Server and I don't know the best newsgroups yet. ... > Does a Unique Identifier data type take up less storage space than a 32 ... A uniqueidentifier uses 16 bytes. ... but I'm looking at the data types and think that the TimeStamp ...
(microsoft.public.sqlserver.programming)
Re: Retrieving a Guid from a DataTable
... the column has a Uniqueidentifier data type. ... the GUID is stored as a Uniqueidentifier in the database. ... ArrayList ReadingRange = new ArrayList; ...
(microsoft.public.dotnet.languages.csharp)
Re: Data Types
... >> character varchar data type? ... A uniqueidentifier uses 16 bytes. ... > of UPDATEs. ... >> When specifying a TimeStamp field, can you tell it only to update the ...
(microsoft.public.sqlserver.programming)