当比较具有不同数据类型的值时，SQL Server非常明智。
以下脚本按原样工作，无需任何显式转换
DECLARE @TableA TABLE (VARCHARID VARCHAr(48) PRIMARY KEY)DECLARE @TableB TABLE (GUIDID UNIQUEIDENTIFIER PRIMARY KEY)INSERT INTO @TableA VALUES ('{0CAF3FBC-3C76-420B-B0C4-42867551E3B5}') , ('{0CAF3FBC-3C76-420B-B0C4-42867551E3B6}') , ( '0CAF3FBC-3C76-420B-B0C4-42867551E3B7' ) , ( '0CAF3FBC-3C76-420B-B0C4-42867551E3B8' )INSERT INTO @TableB VALUES ('{0CAF3FBC-3C76-420B-B0C4-42867551E3B5}') , ( '0CAF3FBC-3C76-420B-B0C4-42867551E3B6' ) , ('{0CAF3FBC-3C76-420B-B0C4-42867551E3B7}') , ( '0CAF3FBC-3C76-420B-B0C4-42867551E3B8' )SELECt *FROM @TableA a INNER JOIN @TableB b ON b.GUIDID = a.VARCHARID结果
VARCHARID GUIDID{0CAF3FBC-3C76-420B-B0C4-42867551E3B5} 0CAF3FBC-3C76-420B-B0C4-42867551E3B5{0CAF3FBC-3C76-420B-B0C4-42867551E3B6} 0CAF3FBC-3C76-420B-B0C4-42867551E3B60CAF3FBC-3C76-420B-B0C4-42867551E3B7 0CAF3FBC-3C76-420B-B0C4-42867551E3B70CAF3FBC-3C76-420B-B0C4-42867551E3B8 0CAF3FBC-3C76-420B-B0C4-42867551E3B8
