全局唯一标识符 GUID 

 1 CREATE    TABLE dbo.SurrogateTable
 2     (
 3       IdentityColumn INT IDENTITY(1, 1)
 4                          NOT NULL ,
 5       GUIDColumn UNIQUEIDENTIFIER NOT NULL
 6                                   DEFAULT NEWID() ,
 7       DataColumn NVARCHAR(50) NOT NULL
 8     )
 9 -----------------
10 INSERT INTO dbo.SurrogateTable(DataColumn )
11 VALUES
12 (N'测试数据1'),
13 (N'测试数据2');
14 --------------------
15 SELECT * FROM dbo.SurrogateTable

输出：

IdentityColumn GUIDColumn                           DataColumn
-------------- ------------------------------------ --------------------------------------------------
2              44880308-11B5-41BF-A64E-2C12037C810B 测试数据1
3              8CE5BCC7-56A9-4EE1-9982-EDD79B07050F 测试数据2

posted @ 2014-05-03 22:25  海阔天空XM  阅读(120)  评论(0)    收藏  举报