SQLServer中的大小写转换-UppertoLowercaseconversioninSQLServer

I have the below columns in from 2 different tables -

我有以下列从两个不同的表-

DimTeamProject.ProjectNodeGUID             DimIteration.ProjectGUID 
------------------------------             ------------------------   
FAE8B08E-286E-487D-B1C1-011853028CDB       fae8b08e-286e-487d-b1c1-011853028cdb

I was trying a join operation while matching the case. It gave me an error like

在匹配这个案例时，我尝试了一个连接操作。它给了我一个错误

Conversion failed when converting from a character string to uniqueidentifier.

当从字符串转换为惟一标识符时，转换失败。

The query I was trying was -

我正在尝试的查询是-

select 
   p.ProjectNodeName, i.IterationName
from 
   DimTeamProject p, DimIteration i
where 
   (p.ProjectNodeGUID) = UPPER(i.ProjectGUID)

I tried the "char" and "cast" function too but without success. Please help.

我也尝试了“char”和“cast”功能，但没有成功。请帮助。

DimIteration.ProjectGUID is an "nvarchar" & DimTeamProject.ProjectNodeGUID is an "uniqueidentifer"

DimIteration。project ectguid是一个“nvarchar”和dimteamid项目。ProjectNodeGUID是一个“uniqueidentifer”

1 个解决方案

select p.ProjectNodeName, i.IterationName
from DimTeamProject p
inner join DimIteration i on p.ProjectNodeGUID = 
    CAST(i.ProjectGUID as uniqueidentifier)