Ispirer Ispirer
 


Ispirer Home Page Ispirer SQLWays Product Page - Migration to SQL Server Request SQLWays

SQL Server Data Types - UNIQUEIDENTIFIER

Versions: SQL Server 2008, 2005, 2000, 7.0 and 6.5

SQL Server - UNIQUEIDENTIFIER
Syntax UNIQUEIDENTIFIER
Data Globally unique identifier (GUID)
Storage Size 16 bytes
Standards SQL Server Extension

An example of UNIQUEIDENTIFIER:

6F9619FF-8B86-D011-B42D-00C04FC96431

SQL Server UNIQUEIDENTIFIER - Equivalents in Other Databases

Database Data Type and Conversion
PostgreSQL UUID
Sybase ASE CHAR(32) for UUID values without dashes, or CHAR(36) for UUID values with dashes; NEWID() function can be used to generate UUID values

All Data Types


Ispirer Home Page Ispirer SQLWays Product Page - Migration to SQL Server Request SQLWays

sqlways/sql-server/data-types/uniqueidentifier.txt · Last modified: May 07, 2018, 03:15:34 PM (external edit)
 
© 1999-2019, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement