34,590
社区成员
发帖
与我相关
我的任务
分享
CREATE TABLE #t2(gid UNIQUEIDENTIFIER )
go
INSERT #t2(gid) VALUES(NEWID())
GO 10
SELECT * FROM #t2
/*
gid
------------------------------------
84E87A41-9817-49E6-A256-B42BA253B5CA
D200458E-1998-4862-A2D6-2E6CF30EE7A4
325AAE03-2DD6-4F50-8725-E284853AB433
93FBC13D-8F6E-45FC-814F-EBB1BBCCCC46
9038955C-2DD3-4768-88D0-D9F3910A9490
A0FB9E7E-2813-45A0-9DB7-051967DA2A61
E1EFC8E9-8C49-4BD2-8628-072707B3CCB0
FBC4BF2D-2DF6-4DE3-B010-ED3E9DB0116A
C651C2A3-895C-4AA9-9F38-08B4F11ACD64
5E5C97D0-84FF-47E1-9805-8FD5B2BDEDCB
*/
SELECT * FROM #t2 WHERE gid LIKE '84E87A41-9817-49E6-%'
SELECT * FROM #t2 WHERE gid = 'D200458E-1998-4862-A2D6-2E6CF30EE7A4'
SELECT * FROM #t2 WHERE gid = '{D200458E-1998-4862-A2D6-2E6CF30EE7A4}'
都能返回结果