sqlserverのGUIDグローバル一意ID

--単純で実用的なグローバル一意のID
 
DECLARE @myid uniqueidentifierSET @myid = NEWID()PRINT 'Value of @myid is: '+ CONVERT(varchar(255), @myid)
 
--結果セット

Value of @myid is: 6F9619FF-8B86-D011-B42D-00C04FC964FF

CREATE TABLE cust
(
 CustomerID uniqueidentifier NOT NULL --  newid()      uniqueidentifier     
   DEFAULT newid(),
 Company varchar(30) NOT NULL,
 ContactName varchar(60) NOT NULL, 
 Address varchar(30) NOT NULL, 
 City varchar(30) NOT NULL,
 StateProvince varchar(10) NULL,
 PostalCode varchar(10) NOT NULL, 
 CountryRegion varchar(20) NOT NULL, 
 Telephone varchar(15) NOT NULL,
 Fax varchar(15) NULL
)
GO