如何能生成这种类型的字符串{063C2AB6-2853-49B5-93B0-032974B05B8B}

Question

如何能生成这样的字符串并把这个字符串格式设为id的默认值,并且这个字符串是动态的

Answer 1

select id=newid()/*
id
------------------------------------
A365FEA9-40B9-406C-8CB5-EE91DFFAC9F4(1 row(s) affected)
*/

Answer 2

create table tb(
id uniqueidentifier default(newid()),
n int
)insert tb(n) values(1)select * from tbdrop table tb/*
(1 row(s) affected)
id                                             n
------------------------------------ -----------
7025AA95-A1A9-4DA6-867C-C11D9D59C842           1(1 row(s) affected)
*/

Answer 3

4977D377-58AE-4778-8A2F-027DD3911ABD

Answer 4

create table mumu1980 
(
    ID uniqueidentifier default(newid()),
    name varchar(50)
)insert  into mumu1980(name) values('AAAA')
insert  into mumu1980(name) values('BBBB')
insert  into mumu1980(name) values('CCCC')
insert  into mumu1980(name) values('DDDD')
select * from mumu1980
-------------------
ID                                      name
79E735A8-06DC-4B12-AE61-D135CCC17AB5 AAAA
905ABAA6-76B7-4B1C-B362-DD9FCFEA800F BBBB
4313A795-EF16-4BE7-A7A5-B266691A5AC1 CCCC
C5B9D0A4-F5F1-4622-BE90-C73BEC1F2216 DDDD